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:47:13
|
GuysI 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 301630003016WYSONG RTM 301650003016WYSONG 30166000301600050012001400CWEST 3016 6000301600050012001500CWEST 30161000301719740214WDWARNTY 3017 2000301719740214000 301730003017WYSONG2 3017The 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, 3017) 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 |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|