Archive for the ‘SQL XML’ Category

TSQL – Concatenate Rows Into On Column Using For XML Path()

This case always happen when you are working  with large business that you need Concatenate rows into one string . one of the methods to do that is to Use XML Path() to turn rows into one XML with no tags. As follows 1)  Declare To Tables With one to many relation DECLARE @Categories TABLE ( CategoryID INT, Category_Code […]

More »