hi i keep my purchase and issue in my transaction table with type 0 and 1. now i want to retrieve sum of purchase and issue in single row with two column. my query is.........
select (case when TransType = 0 then SUM(Amount) end) PurchaseAmt, (case when TransType = 1 then SUM(Amount) end) IssueAmt from TransMaster where TransType in (0,1) group by TransType abov query return following thow row.
[PurchaseAmt IssueAmt but my expectation is single row as following.
is it possible ? thanks to all.