naming columns - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

naming columns

Author

Topic

yenchew
Starting Member

1 Post

Posted - 2004-08-16 : 16:30:38

Hello y'all!

Trying to see how I can name the heading in an union query.
SELECT
'SAVANNAH','9579','Q6ANUMERATOR',
COUNT(Q6A) AS NQ6A
FROM dbo.Jul04
WHERE
(Q6A IN (4) or Q6A in (5))
AND CALLDATE BETWEEN '07/01/2004' AND '07/31/2004'
AND CORP IN (9579)
UNION
SELECT
'SAVANNAH','9579','Q6BNUMERATOR',
COUNT(Q6B) AS NQ6B
FROM dbo.Jul04
WHERE
(Q6B IN (4) or Q6B in (5))
AND CALLDATE BETWEEN '07/01/2004' AND '07/31/2004'
AND CORP IN (9579)

the results came out as follow:

No_column_name No_column_name No_column_name No_column_name
SAVANNAH 9579 Q6ANUMERATOR 98
SAVANNAH 9579 Q6BNUMERATOR 99

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-08-16 : 16:42:12

SELECT
'SAVANNAH' as Col1Name,
'9579' as Col2Name,
'Q6ANUMERATOR' as Col3Name,
COUNT(Q6A) AS NQ6A
FROM dbo.Jul04
WHERE
(Q6A IN (4) or Q6A in (5))
AND CALLDATE BETWEEN '07/01/2004' AND '07/31/2004'
AND CORP IN (9579)
UNION
SELECT
'SAVANNAH' as Col1Name,
'9579' as Col2Name,
'Q6BNUMERATOR' as Col3Name,
COUNT(Q6B) AS NQ6B
FROM dbo.Jul04
WHERE
(Q6B IN (4) or Q6B in (5))
AND CALLDATE BETWEEN '07/01/2004' AND '07/31/2004'
AND CORP IN (9579)

Not sure what to do about the aggregate though. If you want it to be the same column it should have the same heading. If you want it be different columns you'll need to add extra columns so each query matches up.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources