stuff.sql

SELECT TOP 100 pi.SubscriberId,
  STUFF((
    SELECT ',' + tct.CategoryType + '=' + tc.CategoryDescription 
    FROM TSL_User_Categories tuc 
	LEFT JOIN TSL_Categories tc ON tc.CategoryId=tuc.CategoryId 
	LEFT JOIN 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