Home Forums SQL Server 2005 T-SQL (SS2K5) tsql query for counting a 'grouped by' and a where clause RE: tsql query for counting a 'grouped by' and a where clause
mrichardson 57577
Right there with Babe
Points: 739
More actions
August 13, 2013 at 3:41 am
#1640842
Thanks a lot, that works!
(I just had a minor error on my code - I should have put if >0 and not 1)
also changed to COALESCE instead of ISNULL