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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Conversion from dump file

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 col2
1000301619740214WDWARNTY 3016
2000301619740214000 3016
30003016WYSONG 3016
50003016WYSONG 3016
6000301600050012001400CWEST 3016
6000301600050012001500CWEST 3016


The 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 helpful

Thanks

   

- Advertisement -