Example of STUFF or FOR XML Path in SQL

This query is helpful when you want to make CSV type data for a relational table column Query   

 DECLARE @culture nvarchar(50)='en'

  SELECT REPLACE(STUFF((

            SELECT ',' + (CASE WHEN @culture='en' THEN esf.[Name_en] WHEN @culture='jp' THEN esf.[Name_jp] ELSE esf.[Name_jp] END)

             FROM [dbo].[Staff.ProfessionalSpeciality] Sps

  INNER JOIN [Master.EstimationSpecializedField] esf ON Sps.ProfessionalID = esf.ID 

  WHERE Sps.IsSelected = 1 AND Sps.StaffID= '875435ad-4851-48ad-8082-e1b687a9c3e3'

            FOR XML PATH('')

            ), 1, 1, ''),'&','&')