Home Forums SQL Server 2008 SQL Server 2008 - General Save row counts of multiple query results RE: Save row counts of multiple query results

  • August 3, 2010 at 3:46 am

    #1201415

    I think what you're looking for is:

    select 'SE_Country' as col1, count(*) from .....

    union all

    select 'FE_Country' as col1, count(*) from ....

    union all