Tag: case

SQL case

MS SQL case .. when snippet


This MS SQL case when snippet

SELECT invoice ,
case
when  isnull(sum(tr.cramount),0)>isnull(sum(tr.dramount),0)  then isnull(sum(tr.cramount),0)-isnull(sum(tr.dramount),0) 
else 0
end as cr,
case  
when  isnull(sum(tr.dramount),0)>isnull(sum(tr.cramount),0)  then isnull(sum(tr.dramount),0)-isnull(sum(tr.cramount),0) 
else 0
end  as dr
  
FROM transactions AS tr INNER JOIN accounts AS ac ON tr.DRID
 = ac.id inner join accounts ac1 on tr.crid=ac1.id  group by  invoice,tr.drid