• One other way to do it then is to have the headers turned off and have the first first row of your select the column names, something like:

    SELECT 'COLUMN1', 'COLUMN2',....

    FROM Blah UNION

    SELECT COLUMN1, COLUMN2

    FROM Blah

    MCITP SQL 2005, MCSA SQL 2012