USP_DATALIST_MARKINGCOLUMNSET

CREATE procedure dbo.USP_DATALIST_MARKINGCOLUMNSET
as
    set nocount on;

    select ID,
           NAME,
           (select stuff(( select '; ' + MARKINGCOLUMN.DISPLAYNAME
                           from dbo.MARKINGCOLUMN
                               join dbo.MARKINGCOLUMNDESCRIPTIONCODE on MARKINGCOLUMNDESCRIPTIONCODE.ID = MARKINGCOLUMN.MARKINGCOLUMNDESCRIPTIONCODEID
                           where MARKINGCOLUMN.MARKINGCOLUMNSETID = MARKINGCOLUMNSET.ID
                           order by MARKINGCOLUMN.SEQUENCE
                           for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, '')) as MARKINGCOLUMNS

    from dbo.MARKINGCOLUMNSET