exporting duplicate column data

[alfie002]

Hello all,

I need to export data from a MS SQL server. I am using the export wizard to do so. However,I need to export mutliple instances of the same columns. EG


datetime, ps, recnum, customer, ps, count, probe, count

Using the standard query builder I am not able to select mulitple like columns. Equally, using a custom query I still cannot do this. Does MS SQL (select command) support the ability to select multiple columns ?

Thanks

Alf

 

[Otto]

Try to give different names for the same fields.

select datetime, ps, recnum, customer, ps as ps2, count, probe, count as count2

 

[alfie002]

Hello Otto,

thanks for the response. Much appreciated.

Otto, is there a way to select to columns, append them together and export as one column?

EG:

Column column
servicename Target

The output being:

servicename_target

Thanks


Alf

 

[PatriciaObreja]

Select servicename + '_' + target from Table

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[alfie002]

thanks PatriciaObreja.