calculated columns in sql server
I frequently suffer from Mondayitis but it can strike on Tuesdays too! I was creating a stored procedure in SQL Server this morning involving GROUP BY, CASE statements, aggregate functions, ISNULL and COALESCE for good measure. Everything was working fine, except that one of the calculated columns was zero all the way down, even though …