Columns to Rows without using UNION or UNPIVOT
Problem Table contains two or three columns that should be output as a single column over two or three rows. Such as [Telephone1], [Telephone2], … columns in a table. Use Table Values constructor in CROSS APPLY clause Use the table … Continue reading →