Posted by Yas on 06/29/07 18:32

On 29 Jun, 14:27, M A Srinivas <masri...@gmail.com> wrote:
> On Jun 29, 3:09 pm, Yas <yas...@gmail.com> wrote:
>
>
>
> > Hello,
>
> > I was wondering if anyone can help me figure something out.
> > Is it possible to do a querey in MS SQL server and have the results
> > returned so that each result in each row is preceeded by the column
> > name?
>
> > eg. instead of usual output -> colName1, colValue1,
> > colName2,colValue2,colName3,colValue3 ?
>
> > Also I would like to only have this for certain columns ie in the
> > above example only for columns 2 and 3
>
> > Thank you! :-)
>
> > Yas
>
> Not sure what you are actually looking at
>

Hi, thanks for the response. Basically I want to have a query in a DTS
package that outputs to a text file with each line containing 1 row of
results.
What I would like to have is on each line before a given value is
written the column header for that value is also written. the file is
a semicolon delimmeted file so it would look something like this....

col1Name;value1;col2Name;value2;col3Name;value3....etc

so...
FirstName;firstNameValue;SecondName;secondNameValue;Occupation;occupationValue..etc

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?
especially as I want to do this in a DTS package Export Data which
esentially has a create table type command to ouptut to a text file
and throws errors that destination column name not defined.

Thanks :-)


> create table #temp (col1 int, col2 int , col3 varchar(10))
> insert into #temp values (1,10,'abcd')
> insert into #temp values (2,20,'efgh')
>
> select col1, ' col2:'+cast(col2 as varchar(10))+ '-col3:'+col3 as
> col23
> from #temp
>
> drop table #temp

[Back to original message]