SQLTeam.com | Weblogs | Forums

Convert column to Rows

sql2008
sql2008r2

#1

Hi Team,
I need one help , i have below data , want to Convert column to Rows as output. Need help

Input Data

Thanks for your help in advance.


#2

Please post DDL for table and DML for insert(s) like:

CREATE TABLE TableName(Col1...);
GO
INSERT TableName
VALUES
     ('sss',...)
   , ('ttt',...);