Need help for split Multiple Columns into One column..

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

handkot SSCertifiable Points: 5251 More actions · Answer 1

declare @t table(id int, Name varchar(100), Mark1 varchar(100), Mark2 varchar(100), Mark3 varchar(100), Mark4 varchar(100), mark5 varchar(100))

insert into @t values(1, 'AAAA', '75', '85', '45', '65', '85')

select

id

, Details

from

@t t

unpivot (Details for field in (name, mark1, mark2, mark3, mark4, mark5)) unpvt

?

all columns must have same type

I Have Nine Lives You Have One Only
THINK!

panneer.adms Grasshopper Points: 19 More actions · Answer 2

Grasshopper

Points: 19

October 12, 2011 at 1:11 am

Thank you So much