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 |
44443
Starting Member
10 Posts |
Posted - 2005-06-06 : 08:20:21
|
Guys I have exported data from a dump file. I have to now convert into our schema.I have following scenario which is stopping my conversion.col1 col21000301619740214WDWARNTY 3016 2000301619740214000 301630003016WYSONG 301650003016WYSONG 30166000301600050012001400CWEST 3016 6000301600050012001500CWEST 3016The problem is I have to place all the col1 values starting with 1, 2, 3 and having same values of col2 (in this case 3016) in single of row of new table.I have tried using insert subquery with group by clause but it doesnt seem to solve the problem.Any suggestions/insights would be helpfulThanks |
|
|
|
|