Loading

Showing table field in sql server if not equal to 0

Jes Sie

Can anyone help me with my requirement below?

If Debit is not equal to Credit, I want the data to show. But if Debit and Credit is now balance, no data should show. I have no luck with the having clause. Thanks in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya9y ago
Accepted answer
Hello,
If CashierID not required than remove it..
Because in grouping CashierID is not similar in both row.
0
Jes Sie9y ago
Piyush Pansuriya, thanks. Got it already
0
Jes Sie9y ago
Piyush Pansuriya, thanks for your reply. I tried your suggestion but regardless if balance or not, it shows all the data. Please see attached photo.
not balance data:
In the pix above, Debit is greater than Credit, so the data shows.

balance data:
In the photo above, Debit and Credit were already balance, so, therefore this data show not show.

The requirement is that: if Debit = Credit, then no data should show. If Debit > Credit, then data should show.
0
Piyush Pansuriya9y ago
Hello,
Put ISNULL() to all numeric field.
i.e. ISNULL(sr.AccountsReceivable,0)

and change in having like
having sum(ISNULL( sr.AccountsReceivable,0)) - (SUM(ISNULL(ar.Premium,0) + .....)) <> 0
0

Showing table field in sql server if not equal to 0

Piyush Pansuriya, thanks. Got it already

Piyush Pansuriya, thanks for your reply. I tried your suggestion but regardless if balance or not, it shows all the data. Please see attached photo.