Greetings,
Now I have a SQL server table T1 which has one column: Col, and one row. The data looks like this:
a1,a2,a3,b1,b2,b3,c1,c2,c3,...,x1,x2,x3
Now I wish to load it to a new table T2. T2 has three columns: col1, col2,col3, and has many rows. It should look like this:
Table T2
--------------
col1 col2 col3
--------------
a1 a2 a3
b1 b2 b3
c1 c2 c3
.............
x1 x2 x3
I think of export table T1 to disk, and then bulk insert it in to table T2. But there should be other ways using T-SQL (I am not using SSIS).
Thanks,
CUQ