Home Forums SQL Server 2008 SQL Server 2008 - General Transpose rows into one column RE: Transpose rows into one column
MariusC
SSC-Addicted
Points: 442
More actions
July 7, 2014 at 3:49 am
#1727301
I solved it. Yes, the unpivot was the answer. I used the following query :
select Field from myTable UNPIVOT (Field for ColumnName IN ([unic],[nrc],[nr_tel],[id_stud])) unpvt
Thanks!