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 |
|
tristar82
Starting Member
2 Posts |
 Posted - 2013-12-14 : 16:40:56
|
| Hi there,I have a source file that has many columns (25) and want to find the most efficient way to load it into a table with just two columns. I.e I always want be first column to appear so I would want columns 1+2, then 1+3, then 1+4, then 1+5..... Up to 1+25I was thinking of an insert command that pulls data from a staging table - however bit every row uses the full 25 columns- some are only 3 or 4 and I don't want rows in the final table that just have data in first column 1.Any help would be appreciated!! |
|
|
|
|
|
Import many column CSV into 2-column sql table