USP_DATALIST_CORECURRICULUM

CREATE procedure dbo.USP_DATALIST_CORECURRICULUM
as
    set nocount on;

    select CORECURRICULUM.ID,
        dbo.CORECURRICULUM.NAME,
           dbo.UFN_SCHOOL_GETNAME(CORECURRICULUM.SCHOOLID) "SCHOOL",
           ISNULL(dbo.UFN_SCHOOLGRADELEVEL_GETNAMEDESCRIPTION(CORECURRICULUM.SCHOOLGRADELEVELID), '<All grade levels>') "GRADELEVEL",
           dbo.UFN_CORECURRICULUM_GETCOURSESTRING(CORECURRICULUM.ID) "COURSES"
    from dbo.CORECURRICULUM
  inner join dbo.SCHOOL
    on dbo.CORECURRICULUM.SCHOOLID = dbo.SCHOOL.ID