row concatenate in sql server2008

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

Dear sir,

I have following data. i need the data will be one line in sql server2008 Like

Input:

ID Name Marks
1 ABC 50
1 ABC 60
1 ABC 70

Output:
1 ABC 50,60,70

Posted 5-Jun-12 22:55pm

stanly jeba singh

Add a Solution

2 solutions

Add a Solution

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

**AmitGajjar** · Answer 1 · 2012-06-05T23:08:00

Solution 2

Hi,

you can use below query for result,

SQL

DECLARE @Marks VARCHAR(8000)
SELECT @Marks = COALESCE(@Marks + ', ', '') + Marks FROM tableName 
SELECT @Marks

Thanks
-Amit.

Posted 5-Jun-12 23:08pm

AmitGajjar

Comments

codeBegin 6-Jun-12 5:27am

Exact one +5!

AmitGajjar 6-Jun-12 5:28am

Thanks codeBegin.

codeBegin · Answer 2 · 2012-06-05T22:58:00

COALESCE (Transact-SQL)[^]
COALESCE accepts one or more column names of the same data type. The COALESCE function checks the value of each column in the order in which they are listed and returns the first nonmissing value. If only one column is listed, the COALESCE function returns the value of that column. If all the values of all arguments are missing, the COALESCE function returns a missing value.

Coalesce Function[^]
Concatenate many rows into a single text string using SQL Server 2008[^]
Concatenate multiple rows into one column[^]

row concatenate in sql server2008

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

row concatenate in sql server2008

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us