UFN_CORECURRICULUM_GETCOURSESTRING

create function dbo.UFN_CORECURRICULUM_GETCOURSESTRING
(
    @CORECURRICULUMID uniqueidentifier
)
returns nvarchar(1000)
with execute as caller
as begin

    declare @COURSELIST nvarchar(1000)
    select
        @COURSELIST = coalesce(@COURSELIST + '; ', '') + COURSE.COURSEID
    from dbo.CORECURRICULUMCOURSE
        inner join dbo.COURSE on CORECURRICULUMCOURSE.COURSEID = COURSE.ID
    where dbo.CORECURRICULUMCOURSE.CORECURRICULUMID = @CORECURRICULUMID
    order by dbo.COURSE.COURSEID

    return @COURSELIST


end