gistfile1.txt

SELECT TOP 1000 pi.SubscriberId,
  STUFF((
    SELECT ',' + tct.CategoryType + '=' + tc.CategoryDescription 
    FROM SML_Auth.dbo.TSL_User_Categories tuc 
	LEFT JOIN SML_Auth.dbo.TSL_Categories tc ON tc.CategoryId=tuc.CategoryId 
	LEFT JOIN SML_Auth.dbo.TSL_CategoryTypes tct ON tc.CategoryTypeId=tct.CategoryTypeId
    WHERE pi.SubscriberId=tuc.SubscriberId
    FOR XML PATH('')),1,1, '') AS categories 
FROM TES_Connect_SML.dbo.TES_PROFILE_PERSONALINFORMATION pi
GROUP BY pi.SubscriberId
ORDER BY pi.SubscriberId DESC