Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 22 October 2013

Comma Separated Values in SQL Server

Comma Separated Values in SQL Server


select substring(
(select ','+j.jobsdescription from jobdetails J
order by j.jobid
FOR XML PATH('')),2,500) AS CDM