Posted by Yas on 07/01/07 10:52

On 29 Jun, 23:38, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Yas (yas...@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.

Thanks! :-)

• Next in forum: Re: Combining Values
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Re: Output Column names in each Row along with the row Value

[Reply to this message]