Combine the multiple Row value to one row

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 2005 Forums

Transact-SQL (2005)

Combine the multiple Row value to one row

Author

Topic

ambujnema
Starting Member

11 Posts

Posted - 2009-02-26 : 02:19:00

SELECT [filename] FROM ClientFile CF

INNER JOIN VersionFile VF

ON CF.clientfileid = VF.clientfileid

INNER JOIN Version V

ON VF.Versionid = V.Versionid

AND V.workorderid = 9

By Running this query I am getting the output like

FileName
sample1_3_147_1.txt
sample2_4_258_2.txt

I want Output in

FileName
sample1_3_147_1.txt,sample2_4_258_2.txt

this format

Please help me how to approach ?

Thanks

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-02-26 : 02:27:59

try like this


SELECT STUFF((SELECT ','+ [filename] 
FROM ClientFile CF
INNER JOIN VersionFile VF ON CF.clientfileid = VF.clientfileid
INNER JOIN Version V ON VF.Versionid = V.Versionid
						AND V.workorderid = 9 
FOR XML PATH('')),1,1,'')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources