Modify columns to rows in SQL Server

Question

How to convert columns to rows in SQL Server?

For example I have table with 31 columns as numbers from 1 to 31.

PFA screenshot for the same.

These no should range from 1 to 31 in row format.

You might want to look into `UNPIVOT. Here is a nice little example: stackoverflow.com/questions/19055902/unpivot-with-column-name — Ralph
– Ralph, Commented May 15, 2016 at 21:13
you should post expected result too ,good way to ask question to get better answers:spaghettidba.com/2015/04/24/… — TheGameiswar
– TheGameiswar, Commented May 15, 2016 at 21:27

Alan Burstein · Accepted Answer · 2016-05-15 21:12:25Z

1

Or, "An Alternative (Better?) Method to UNPIVOT (SQL Spackle)" by Dwain Camps found here: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

answered May 15, 2016 at 21:12

Alan Burstein

8,0061 gold badge18 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1