SELECT isnull(WO_status,0) as WO_status,
(case when MwO.WO_status=1 then 'Open' when MwO.WO_status=2 then 'Close' when MWO.WO_status=3 Then 'Short Close'
when MwO.WO_status=4 then 'Cancel'
else 'Total' end) as statusR,
count(*) as countValue
FROM M_WorkOrder MwO
inner join M_WorkorderDetails MwOd on MwO.WOID=MwOd.WOD_WOID
INNER join BILL_KEYWORD BK on BK.id=MwOd.WOD_KEYID
INNER join billing_from bf on bf.id=MwO.WO_CID
where (MwOd.WOD_CUserID=15 or 15 =0 )
group by WO_status WITH ROLLUPThis code snippet for SQL Group With group Total.
