Home Forums SQL Server 2008 SQL Server 2008 - General sql query RE: sql query
Eklavu
Right there with Babe
Points: 790
More actions
January 21, 2013 at 1:34 am
#1579117
select Col
from (select * from dbo.TESTTB) as X
unpivot (Col for cols in (col1, col2, col3)) as Y