InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:20:47 GMT20http://www.sqlservercentral.com/Forums/Topic802594-1672-1.aspxHi We Can concenate Rows by using the COALESCE Statement as follows. For example if we want to concenate the Name data as "Ram,Shyam,Basha,Shiva" from Emp table.CREATE TABLE #Emp(ID INT, Name VARCHAR(40))INSERT #Emp SELECT 1, 'Ram'INSERT #Emp SELECT 2, 'Shyam'INSERT #Emp SELECT 3, 'Basha'INSERT #Emp SELECT 4, 'Shiva'ID Name1 Ram2 Shyam3 Basha4 ShivaDECLARE @EmplList VARCHAR(400)SELECT @EmpList = COALESCE(@EmpList,'')+CASE WHEN COALESCE(@EmpList,'') <> '') AND COALESCE(Name,'') <> '' THEN ',' ELSE '' END + COALESCE(Name,'') FROM #Emp Order BY IDSELECT @EmpListDROP TABLE #EmpResultRam,Shyam,Basha,ShivaWed, 14 Oct 2009 03:29:20 GMTtmahaboobbasha