Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 grouping a varchar rows with varchar id

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2009-12-15 : 17:28:14
hi friends

i have a sql table in following way

customerid product

rut12 fan
rut12 table
rut12 light
rut13 jewellery
rut12 appliances
.... so on

i need to show the result of query in this way


customerid product

rut12 fan,table,light
rut13 jewellery,appliance

...so on ..


how can i achieve this... thanks in advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-16 : 02:02:11
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2009-12-22 : 10:19:40
thank you madhivanan . it worked.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-23 : 01:14:31
quote:
Originally posted by akpaga

thank you madhivanan . it worked.


You are welcome

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -