Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2013-02-18 : 22:25:38
|
How can i add in the pipe delimited in TXT format?select '"' + FirstName + '"' [FName], '"' + LastName + '"' [LName]from tableAI would like the result as below:"FirstName","LastName""Mary"|"Jane""John"|"Wayne"Can I do that? Using BCP? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2013-02-19 : 02:35:30
|
But it doesnt include the column.How can I do that? |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-19 : 04:08:10
|
I am not sure if this helps but you can do that in a simple way using Import/Export optionImport the table name you wanted to select in source and export in text file, change the delimited to vertical pipe and run the mapping. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|