UFN_APPUSERSESSION_GETHEADERTEXT

create function dbo.UFN_APPUSERSESSION_GETHEADERTEXT
(
    @CURRENTAPPUSERID uniqueidentifier
)
returns @RESULTS TABLE
(
    SESSIONID uniqueidentifier,
    ACADEMICYEARID uniqueidentifier,
    HEADER nvarchar(200),
    SCHOOLID uniqueidentifier
)
as begin

    insert into @RESULTS
    select
        dbo.SESSION.ID,
        dbo.ACADEMICYEAR.ID,
        case when dbo.UFN_SCHOOL_ISSINGLESCHOOL() = 0
            then dbo.UFN_SCHOOL_GETNAME(ACADEMICYEAR.SCHOOLID) + ', '
            else ''
        end + dbo.UFN_ACADEMICYEARNAMECODE_GETDESCRIPTION(ACADEMICYEAR.ACADEMICYEARNAMECODEID) + ', ' +
            dbo.UFN_SESSIONNAMECODE_GETDESCRIPTION(SESSION.SESSIONNAMECODEID),
        SCHOOLID
    from dbo.SESSION
        inner join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
        inner join dbo.APPUSERSESSION on SESSION.ID = APPUSERSESSION.SESSIONID
    where dbo.APPUSERSESSION.ID = @CURRENTAPPUSERID

    return
end