PIVOT

[Mugdha_Aditya]

I have a table with only one column as Emp_Name A B C D E I want to display this data as Emp_Name A, B, C, D, E Please help me as soon as possible

[JHizzle]

I'm not sure I understand, could you elaborate please? It looks like you're wanting to merge every record in a table into one? That's sort of anti-database design, no?

[Lost User]

Mugdha_Aditya wrote:

Please help me as soon as possible

Start here[^] :)

I are Troll :suss:

[Niladri_Biswas]

Try this declare @t table(Emp_Name varchar(50)) insert into @t select 'A' union all select 'B' union all select 'C' union all select 'D' union all select 'E' Solution 1: declare @concat varchar(100) set @concat = '' select @concat = @concat + Emp_Name + ',' from @t select Emp_Name =Left(@concat,len(@concat)-1) Solution 2: select Emp_Name = RIGHT(delimitedCol,len(delimitedCol)-1) from (select ',' + CAST(Emp_Name AS varchar(8000)) from @t for xml path(''))x(delimitedCol) Output(For both the cases)**

Emp_Name
A,B,C,D,E

**Even you can use while loop , cursors but the approaches mentioned above are faster enough. :)

Niladri Biswas

[nainakarri]

Can i know the reason why you want to use Pivot? Using For XML PATH('') also you can get the same result. select emp_name + ', ' from tabble where condition for xml path('') Regards Naina

Naina