Q&A for scientists using computers to solve scientific problems
CREATE TABLE #yt (VendorID INT, Emp1 INT, Emp2 INT, Emp3 INT, Emp4 INT, Emp5 INT); INSERT INTO #yt VALUES (1,4,3,5,4,4); select v.col from #yt cross apply (values (Emp1), (Emp2), (Emp3), (Emp4), (Emp5)) v(col);