If all the queries in combined by the UNION statement are quering the same table (or differenet tables but the coumn names are the same), then you shoudn't need to use AS <header>, correct?
You don't need the AS header in SQL Server at all. SQL gets the result column names from the first
query in a UNION. The others can have different column names -- or no column names at all.
SELECT 1 AS a, 2 AS b
select 3 as c, 4 as d
select 5 as e, 6 as f
select 7, 8
SQL DBA,SQL Server MVP(07, 08, 09)[size=2]Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them.[/size]