need one query to get the result as shown

Question

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

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

Cory E. SSCertifiable Points: 7076 More actions · Answer 1

Oops, I missed that you wanted all the values of B.Col2 on one line. This does not get you that. Removed code. Sorry

-- Cory

Ben Teraberry SSChampion Points: 11845 More actions · Answer 2

declare @t_table1 table

(Col1int)

insert into @t_table1

select 11 union

select 22 union

select 33 union

select 44

declare @t_table2 table

(Col1int,

Col2varchar(10))

insert into @t_table2

select 11, 'ab' union

select 11, 'ac' union

select 11, 'ad' union

select 22, 'jk' union

select 22, 'jy' union

select 44, 'tttt'

select t1.Col1,

stuff((SELECT ', ' + replace(Col2, ' ', '')

FROM @t_table2 t2

WHERE t2.Col1 = t1.Col1

ORDER BY Col2

FOR XML PATH('')), 1, 2, '') AS Vals

from @t_table1 t1

order by t1.Col1

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

reddy06 SSC-Addicted Points: 403 More actions · Answer 3

SSC-Addicted

Points: 403

May 10, 2010 at 1:45 pm

Thanks a lot sir

It is working for me...