yes, ChrisM's query is simple aswell it is more efficient and Optimized too..
--Estimated Subtree Cost = 0.0034222 (to calculate 21.6 rows)
select Field from #tempunpivot UNPIVOT (Field for ColumnName IN ([unic],[nrc],[nr_tel],[id_stud])) unpvt
--Estimated Subtree Cost = 0.0034131 (to Calculate 24 rows)
SELECT NewColumn
FROM #tempunpivot t
CROSS APPLY (VALUES (unic), (nrc), (nr_tel), (id_stud)) d (NewColumn)
I would like to stick with "Cross Apply", Query thanks to ChrisM & Mouris..
Regards,
Prabhu