document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1.  
  2. SELECT      CAT.Name AS [Category],
  3.             SUB.Name AS [Sub Category]
  4. FROM        Production.ProductCategory CAT
  5. INNER JOIN  Production.ProductSubcategory SUB
  6.             ON CAT.ProductCategoryID = SUB.ProductCategoryID
  7.  
  8. =====================================================================
  9.  
  10. SELECT      CAT.Name AS [Category],
  11.             STUFF((    SELECT \',\' + SUB.Name AS [text()]
  12.                         – ADD a comma (,) BEFORE each VALUE
  13.                         FROM Production.ProductSubcategory SUB
  14.                         WHERE
  15.                         SUB.ProductCategoryID = CAT.ProductCategoryID
  16.                         FOR XML PATH(\'\') – SELECT it AS XML
  17.                         ), 1, 1, \'\' )
  18.                        – This IS done TO remove the FIRST CHARACTER (,)
  19.                         – FROM the RESULT
  20.             AS [Sub Categories]
  21. FROM  Production.ProductCategory CAT
');