sql querry fetch data

Question

1.00/5 (1 vote)

See more:

hello
i have a table tb_product has two columns product and part no

product-----------part_no
1------------------ a
1------------------ b
1------------------ c
1------------------ d
1------------------ e
2------------------ a
2------------------ b
2------------------ c
3------------------ a
3------------------ b
3------------------ c

i wanna output like that
product----------- part no
1------------------ a,b,c,d,e
2----------------- a,b,c
3----------------- a,b,c

please write a query for this output.......

thanks & regards
Srishti

Posted 4-Apr-13 19:32pm

srishti_

Add a Solution

3 solutions

Solution 1

It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

Posted 4-Apr-13 19:39pm

Sandeep Mewara

Comments

RedDk 5-Apr-13 12:26pm

And THIS is a rant ...

Sandeep Mewara 5-Apr-13 13:17pm

Well, this is an advice. Now it depends on you if you take it otherwise.

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)

Aarti Meswania · Accepted Answer · 2013-04-04T19:44:00

Solution 2

SQL

select distinct product,stuff((select ',' + part_no from TblNm t
where t.product=a.product FOR XML PATH('')),1,1,'') as a
from TblNm as a

Happy Coding!
:)

Posted 4-Apr-13 19:44pm

Aarti Meswania

Updated 4-Apr-13 19:45pm

v2

Comments

srishti_ 5-Apr-13 1:51am

This query show an error that.... "The multi-part identifier "a.product" could not be bound."

Aarti Meswania 5-Apr-13 1:54am

it's ...
select distinct product,stuff((select ',' + part_no from TblNm t
where t.product=a.product FOR XML PATH('')),1,1,'') as Part_No
from TblNm as a

srishti_ 5-Apr-13 2:00am

now ok thanks

Aarti Meswania 5-Apr-13 2:15am

Welcome!
Glad to help you!:)

Maciej Los · Accepted Answer · 2013-04-04T19:51:00

Solution 3

Try this:

SQL

SELECT  t1.[product], STUFF( (SELECT ', ' + [part_no] AS 'text()' 
                  FROM YourTable AS t2
                  WHERE t2.product = t1.product
                  FOR XML PATH('')), 1, 1, '') AS [Keywords]
FROM YourTable AS t1
GROUP BY t1.[product]

Posted 4-Apr-13 19:51pm

Maciej Los

Comments

srishti_ 5-Apr-13 1:54am

thanks

Maciej Los 5-Apr-13 1:55am

You're welcome ;)

Sandeep Mewara 5-Apr-13 1:59am

For this once I am not voting Mac.

It's clearly a homework without any effort whatsoever. Another link to same question by another member: http://www.codeproject.com/Questions/572798/NeedplusaplusQueryplusforplusbelow

Looks like homework of the day!

Maciej Los 5-Apr-13 2:01am

OK ;)

Maciej Los 5-Apr-13 3:02am

2 stars for worknig example??? I don't get it.