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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-11 : 09:18:14
|
| vidya krishnan writes "Hi!!!! Need some quick help on SQL.....DTS packages. I’ve loaded data from text files into a table which is in the following format..... Seq_No | Row_No | Data 1 1 ABC 2 2 DEF 3 3 GHI 4 4 JKL 5 1 MNO 6 2 PQR 7 3 STU 8 4 VWX Every four lines correspond to one single logical record. So, all the data in every 4 rows have to be combined into one big string which’ll then be loaded into one col of another temporary table .....structure below..... Record_No Data 1 ABCDEFGHIJKL 2 MNOPQRSTUVWX I’m looking for a way to achieve this WITHOUT using Cursors (as it’ll slow down performance)......please give us information on SET PROCESS.Any suggestions will be highly appreciated." |
|
|
|
|
|
combining text data rows