p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2005 (http://p2p.wrox.com/forumdisplay.php?f=220)
-   -   SQL Query Problem (http://p2p.wrox.com/showthread.php?t=62228)

mike.chary September 21st, 2007 10:57 AM

SQL Query Problem
 
My problem is

CREATE TABLE Test
(ID INT,
 lang1 char(3));

INSERT INTO VALUES(1, 'ENG')
INSERT INTO VALUES(1, 'JPN')
INSERT INTO VALUES(1, 'PRB')
INSERT INTO VALUES(2, 'SPC')
INSERT INTO VALUES(2, 'ENG')
INSERT INTO VALUES(3, 'JPN')
INSERT INTO VALUES(3, 'PRB')
INSERT INTO VALUES(3, 'SPC')

I want output liks this

ID Lang1
1 ENG,JPN,PRB
2 SPC,ENG
3 JPN,PRB,SPC

Please help

Thanks in advance

Peso September 26th, 2007 06:19 AM

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254




All times are GMT -4. The time now is 11:48 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.