Posted by Erland Sommarskog on 06/29/07 21:38

Yas (yasar1@gmail.com) writes:
> Now I can just do...
> SELECT 'FirstName', firstName, 'SecondName', secondName,
> 'Occupation' occupation
> FROM Table1
> Which would output the table I want with the values between '' showing
> up in unnamed columns.... BUT is there a better way of doing this?

That would indeed be the way to do it.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Combining Values
• Prev in forum: Re: Connecting to SQL 2005 using VB6
• Thread view: Re: Output Column names in each Row along with the row Value

[Reply to this message]