UFN_BBNC_GETAPPEALBYID

        create function dbo.UFN_BBNC_GETAPPEALBYID
            (
                @ID int
            )
            returns nvarchar(100)
            as
            begin
                return
                (
                    SELECT top 1 APPEAL.NAME
                    FROM dbo.APPEAL 
                    left join dbo.EVENT on EVENT.APPEALID = APPEAL.ID 
                    left join dbo.EVENTAPPEAL on APPEAL.ID = EVENTAPPEAL.APPEALID 
                    left outer join dbo.BBNCAPPEALIDMAP on APPEAL.ID = BBNCAPPEALIDMAP.APPEALID
                    WHERE
                    BBNCAPPEALIDMAP.ID =@ID
                    and APPEAL.ISACTIVE = 1

                )
            end