Home Forums SQL Server 7,2000 General UNION question RE: UNION question
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
April 28, 2005 at 11:19 am
#555610
You could always do something like this :
select 'A' as Data, count(*) from dbo.SysColumns
union ALL
select 'B', count(*) from dbo.SysColumns
Order by Case When Data = 'B' THEN 0 ELSE 1 END