Showing posts with label Convert columns to rows in SQL Server 2008 without unpivot. Show all posts
Showing posts with label Convert columns to rows in SQL Server 2008 without unpivot. Show all posts

Convert columns to rows in SQL Server 2008 without unpivot

Today I will show how to write a query in order to convert the columns to rows in SQL Server 2008 without using the unpivot function:Step 1: Let's analyse the input first which is as shown below:Step 2: Now lets write

Read More