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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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[^]