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

  • 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