Sql Query to Concatenate Rows Group by id

Question

Post reply

Sql Query to Concatenate Rows Group by id

Achiever-785539

Mr or Mrs. 500

Points: 551
More actions
February 25, 2010 at 7:53 am

#216017

Hi All,
I have a requirement that i need to concate rows based on the id. with out using cursors
Can any one help me in this??
In Advance Thanks!!
Regards
Siva

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

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

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 1

What do you mean, concatenate rows? Specific counts, or a however many meet some criteria?

Showing some sample data and DDL would help.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736160

February 25, 2010 at 7:59 am

#1125001

As a hint, a cross tab or PIVOT might be what you need.

handkot SSCertifiable Points: 5249 More actions · Answer 3

see this topic

maybe Paul White post help you

I Have Nine Lives You Have One Only
THINK!

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 4

Achiever-785539 (2/25/2010)
Hi All,
I have a requirement that i need to concate rows based on the id. with out using cursors
Can any one help me in this??
In Advance Thanks!!
Regards
Siva

Some people mean "concatenate" and some people mean "pivot". A before and after example of what you'd like to do would be really helpful in helping you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

kalyan.nimbala Mr or Mrs. 500 Points: 524 More actions · Answer 5

SELECT p1.CategoryId,

( SELECT ProductName + ','

FROM Northwind.dbo.Products p2

WHERE p2.CategoryId = p1.CategoryId

ORDER BY ProductName

FOR XML PATH('') ) AS Products

FROM Northwind.dbo.Products p1

GROUP BY CategoryId ;

i prefer using For XML in this scenario for more inf.

http://www.projectdmx.com/tsql/rowconcatenate.aspx

Achiever-785539 Mr or Mrs. 500 Points: 551 More actions · Answer 6

Sorry for my late reply.

Thanks for all ur suggestions.

I have done it by using xml path in query.

Paul White SSC Guru Points: 150467 More actions · Answer 7

handkot (2/25/2010)
see this topic
maybe Paul White post help you

:w00t:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi