Re: Output Column names in each Row along with the row Value

On 29 Jun, 14:27, M A Srinivas <masri...@xxxxxxxxx> wrote:
On Jun 29, 3:09 pm, Yas <yas...@xxxxxxxxx> 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


.

Relevant Pages

  • Re: temp tables in stored procedures called from dts package
    ... dts package because it is created and dumped once the ... Is there some connection property to use to hold open the ... the stored procedure uses a temp table. ...
    (microsoft.public.sqlserver.dts)
  • DTS Package using c#
    ... I need to create a temp table, import the contents of a text file, add ... I created the DTS package in Enterprise Manager and will be calling it ... but do not know how to change the transform data ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package using c#
    ... DestinationObjectName property of the DataPump task ... I need to create a temp table, import the contents of a text file, add ... I created the DTS package in Enterprise Manager and will be calling it ...
    (microsoft.public.sqlserver.dts)
  • temp tables in stored procedures called from dts package
    ... i'm calling a stored procedure to generate a dataset for importation across ... sql servers. ... the stored procedure uses a temp table. ... the dts package, i get an error message "invalid object #temptablename" ...
    (microsoft.public.sqlserver.dts)