SQL Query to concatenate column values from multiple rows

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

HI,

How to concatenate column values from multiple rows

Table A

FName LName amount Id
A B 100 1
A B 200 2
A C 400 3
A B 300 4

I need the result like :
FName LName totalAmount count Id
---------------------------------------------
A B 600 3 1,2,4
A C 400 1 3

How to get it.

Please help me....

Thanks & Regards

Vineetha..

Posted 22-Aug-14 19:58pm

Vineetha Ravindranath

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-08-22T20:06:00

Solution 1

Use GROUP BY with STUFF: http://stackoverflow.com/questions/16922073/use-coalesce-with-group-by[^]

Posted 22-Aug-14 20:06pm

OriginalGriff

Comments

Vineetha Ravindranath 25-Aug-14 2:30am

Thank you.. It's Working...

OriginalGriff 25-Aug-14 3:00am

You're welcome!

SQL Query to concatenate column values from multiple rows

1 solution

Solution 1

Add your solution here

Preview 0

SQL Query to concatenate column values from multiple rows

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us