Tag: group-by

I have a stored procedure: ALTER PROCEDURE GetReportData AS BEGIN SELECT LOC.SubCompanyNameVN, LOC.BranchName, COUNT(LOC.BranchCode) as Total, ———– Not Processed Yet SUM (CASE WHEN SS.Status IN (5, 6) THEN 1 ELSE 0 END) AS CountNotProcessedYet, ———– Processing SUM (CASE WHEN SS.Status IN (3) THEN 1 ELSE 0 END) AS CountProcessing FROM DBO.WorkingSession AS SS JOIN DBO.Location AS LOC ON SS.LocationID = LOC.LocationID AND SS.BranchCode = LOC.BranchCode JOIN DBO.Status AS ST ON…

View More Use rollup to calculate grand totals with grouping