Board index » MS SQL Server
All times are UTC
Occasionally I process a row in the source (text file) which I need to convert into 2 rows in the destination table.
Is there a good way to do this. (Preferably within the same script and on the same scan of the source file - but all suggestions are very welcome.)
Thanks in advance,
Dave McKinney.
1. Pivoting one source row into multiple destination rows
2. DTS- multiple destination rows for each source row
3. Creating Multiple Destination Rows from a single source Row
4. multiple inserts in destination for each source row
5. Adding Multiple Rows while Transforming from Source to Destination
6. column in multiple rows to multiple columns in one row
7. column in multiple rows to multiple columns in one row
8. Multiple Target Rows from a Single Source Row
9. concatenate varchar field from multiple rows into one row as a group
10. Get values from multiple rows as attributes of one row
11. Combing multiple row data into one row in another table
12. SELECT multiple rows back as one row with many columns
One source row to multiple destination rows