How to convert horizontal row into vertical SQL Server
· I have a Dynamic query which fetch a row with 62 columns in sql The query is like this DECLARE SQLQuery AS NVARCHAR(MAX) DecLare columns nvarchar(max) SELECT columns= ISNULL(columns + ', ','') + QUOTENAME(Column_name) FROM ( Select Column_name FROM (Select Column_name,Row_Number() over ... · Hi Khushboo, Besides UNPIVOT, you could refer ...