fnClassYearNotes

            CREATE function [dbo].[fnClassYearNotes](
                @Guid             uniqueidentifier,
                @IsApproved     integer
            ) returns @results table(ID                 int, 
                                    ClientClassYearsID     int, 
                                    ClassNote             ntext, 
                                    OwnerID             int, 
                                    IsApproved             int, 
                                    ApprovedByID         int,
                                    ApprovedDate         datetime,
                                    PublishDate         datetime, 
                                    ModifiedDate         datetime, 
                                    ExpireDate             datetime, 
                                    DateLastChanged     datetime,
                                    FirstName             nvarchar(100),
                                    LastName             nvarchar(200),
                                    UserName             nvarchar(100),
                                    RaisersEdgeRecordID int 
            )
            as
            begin
                declare @supervisorId integer
                select @supervisorId = dbo.fnGetSupervisorId()

                if @IsApproved = 2
                begin 
                    insert into @results
                    select 
                    b.ID, 
                    b.ClientClassYearsID, 
                    b.ClassNote, 
                    b.OwnerID, 
                    b.IsApproved, 
                    b.ApprovedByID, 
                    b.ApprovedDate,    
                    b.PublishDate, 
                    b.ModifiedDate, 
                    b.ExpireDate, 
                    b.DateLastChanged, 
                    isnull(c.FirstName,b.FirstName) as FirstName,
                    isnull(c.LastName,b.LastName) as LastName,
                    c.UserName, 
                    dbo.fnGetRecordIDFromPeopleID(b.BackOfficeSystemPeopleID) as RaisersEdgeRecordID
                    from ClientClassYears a 
                    inner join ClassYearNotes b on b.ClientClassYearsID = a.ID
                    left outer join ClientUsers c on c.ID = isnull([dbo].[fnGetUserIDFromLinkedPeopleID](b.BackOfficeSystemPeopleID), b.OwnerID)
                    where a.GUID = @Guid
                end
                else
                begin
                insert into @results
                    select 
                    b.ID, 
                    b.ClientClassYearsID, 
                    b.ClassNote, 
                    b.OwnerID, 
                    b.IsApproved, 
                    b.ApprovedByID, 
                    b.ApprovedDate,    
                    b.PublishDate, 
                    b.ModifiedDate, 
                    b.ExpireDate, 
                    b.DateLastChanged,
                    isnull(c.FirstName,b.FirstName) as FirstName,
                    isnull(c.LastName,b.LastName) as LastName,
                    c.UserName, 
                    dbo.fnGetRecordIDFromPeopleID(b.BackOfficeSystemPeopleID) as RaisersEdgeRecordID
                    from ClientClassYears a 
                    inner join ClassYearNotes b on b.ClientClassYearsID = a.ID
                    left outer join ClientUsers c on c.ID = isnull([dbo].[fnGetUserIDFromLinkedPeopleID](b.BackOfficeSystemPeopleID), b.OwnerID)
                    where 
                    a.GUID = @Guid and 
                    b.IsApproved = @IsApproved
                end
                return
            end