Home Forums SQL Server 2008 T-SQL (SS2K8) How to reduce the number of table access from multiple "select count(*) group by" with union all RE: How to reduce the number of table access from multiple "select count(*) group by" with union all

  • February 22, 2013 at 1:27 pm

    #1590511

    This may be way off base but could you add a column to your query and use CASE to populate it based on your A, B & C values? Then you could include that in your GROUP BY.