USP_DATALIST_STUDENT_SKILL_RATING_GROUP

CREATE procedure dbo.USP_DATALIST_STUDENT_SKILL_RATING_GROUP
as
    set nocount on;

    select 
        SRG.[ID],
        SRG.[NAME],
        (select stuff((
                select 
                    '; ' + dbo.STUDENTSKILLRATING.NAME
                from 
                    STUDENTSKILLRATINGGROUP 
                join 
                    STUDENTSKILLRATING on STUDENTSKILLRATINGGROUP.ID = STUDENTSKILLRATING.STUDENTSKILLRATINGGROUPID
                where 
                    STUDENTSKILLRATING.STUDENTSKILLRATINGGROUPID = SRG.ID
                order by 
                    STUDENTSKILLRATING.SEQUENCE
            for xml path(''), type).value('.', 'nvarchar(max)'), 1, 2, ''))
    from 
        dbo.STUDENTSKILLRATINGGROUP as SRG