sql query writing12

Question

Post reply

sql query writing12

asranantha

SSCarpal Tunnel

Points: 4246
More actions
January 8, 2013 at 2:10 am

#287258

hi frieds i have small doubt in sql server plese tell me how to solve this
table data contains like
id , name
1 , a
1 , b
1 , c
2 , a
2 ,b
so i want out put like
id ,name
1 , abc
2 , ab
plese tell me how to write query in sql server

Viewing 7 posts - 1 through 6 (of 6 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

John Mitchell-245523

SSC Guru

Points: 148809

January 8, 2013 at 2:20 am

#1574679

Does this[/url] help?

John

Aadhar Joshi Hall of Fame Points: 3202 More actions · Answer 2

Hi,

Try this..

Hope this will help

SELECT OutTab.ID ,

Names =

STUFF ( ( SELECT ''+InrTab.Name

FROM [empInfo] InrTab

WHERE InrTab.id = OutTab.id

ORDER BY InrTab.id

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)')

, 1,0,SPACE(0))

FROM [empInfo] OutTab

GROUP BY OutTab.id;

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

Always post table defintion along with test data to get faster resultsl.people here steal their time to help others , sometimes they dont have time to frame everything here.please see the link below my signature. 🙂

hope this helps you

declare @t table

(id int , chr char(1))

insert into @t

select 1, 'a' union

select 1, 'h' union

select 1, 'y' union

select 4, 'k' union

select 4, 'f'

select * from @t

select distinct id, STUFF((select '' + cast(chr as nvarchar(20)) from @t where id= t.id FOR XML PATH('')),1,0,'')

from @t t

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

asranantha SSCarpal Tunnel Points: 4246 More actions · Answer 4

hi why here we use XML PATH('')),1,0,''

plese tell me some explnation to use of xml path

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

asranantha (1/8/2013)
hi why here we use XML PATH('')),1,0,''
plese tell me some explnation to use of xml path

BOL has the answer to this and MANY MANY more questions.

http://msdn.microsoft.com/en-us/library/ms178107.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

This article should help some as well: http://www.sqlservercentral.com/articles/comma+separated+list/71700/.