Useful stuff for displaying a column in SQL within a single string, values separated by commas

xml-format.sql

STUFF(
  (
    SELECT ', ' +  mt.[TextValue]
    FROM dbo.[MultiSelect] AS ms
      LEFT JOIN usr.[MonthType] AS mt ON mt.[Ident] = ms.[Value] AND mt.[LanguageID] = @UserLanguageID
    WHERE
      ms.[TableID] = at.[ID]
      AND ms.[FormIdent] = @FormIdent
      AND ms.[ControlIdent] = @ControlIdent
    FOR xml path('')
  ), 
  1,
  1,
  ''
) AS Month,