Get comma Separated Data using XML Path



Select   Qry.*, 

Case When Qry.Door = '' Then Qry.Door Else  

Substring(Qry.Door, 3,Len(Qry.Door) - 2) End As Door

From  

(
SELECT  dbo.tblHardware.Cmp_Id, Hardware_Id , Hardware_Code AS [Hardware Code],

(Select ', ' + cast(Door_Name as varchar)  FROM tbldoor                            WHERE tbldoor.Hardware_Id =tblHardware.Hardware_Id FOR XML path('')) Door

FROM  dbo.tblHardware WHERE (dbo.tblHardware.Is_Deleted = 0)
) As Qry
  
Reference By http://www.c-sharpcorner.com/Blogs/10297/fetch-comma-separated-data-using-xml-path.aspx


Comments

Post a Comment

Popular posts from this blog

Draw Line and Text on Bitmap Image in C#

Hello Friends ,  This is a sample Class example of C#,using this code you can Draw the text and line using Graphics pen on Bitmap images. Sample example code (C# Language - VS.Net) ---------------------------------------------------------------------------------------------------------- using System; using System.Drawing; using System.IO; using System.Diagnostics; using System.Data; using System.Drawing.Imaging; using System.Threading; using System.Collections; using System.Globalization; using System.Windows.Forms; using System.Configuration; using System.Net; using System.Net.Mail; using System.Net.NetworkInformation; namespace MyTest { public class GenerateImage { private Thread [] threads; private System.Collections. Hashtable hashConnectionInfo = new System.Collections. Hashtable (); public string appPath = "E:\\MyPenImage\\" ; public GenerateImage() ...
Read more