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 - 2005-11-29 : 23:57:53
|
| Abs writes "Hi,I have a table with the following columns:quote_no, division, OP, Status, Inception_date,Action1, Action2, Action3.I need to somehow copy each row in to new row, but with on one action per row. So the destination table should look like:1 - quote_no, division, OP, Status, Inception_date, Action12 - quote_no, division, OP, Status, Inception_date, Action23 - quote_no, division, OP, Status, Inception_date, Action3This should be repeated for for each record. So 1 record from source table will create 3 new records, 1 for each action.I would appreciate any help or suggestion.Kind Regards,Abs" |
|
|
|
|
|
|
|
DTS - Copy specific columns to new rows, looped for number