USP_DESIGNATIONLEVELPROFILEREPORT_NOTES

            create proc    dbo.USP_DESIGNATIONLEVELPROFILEREPORT_NOTES (@DESIGNATIONLEVELID uniqueidentifier)
            as
                select 
                    NOTE.ID,
                    NOTE.DESIGNATIONLEVELID,
                    TCODE.DESCRIPTION as NOTETYPE,
                    NOTE.DATEENTERED,
                    NOTE.TITLE,
                    AUTHOR.[NAME],
                    NOTE.TEXTNOTE
                from dbo.DESIGNATIONLEVELNOTE as NOTE
                inner join dbo.DESIGNATIONLEVELNOTETYPECODE as TCODE on NOTE.DESIGNATIONLEVELNOTETYPECODEID = TCODE.ID
                left join dbo.CONSTITUENT as AUTHOR on NOTE.AUTHORID = AUTHOR.ID
                where 
                    NOTE.DESIGNATIONLEVELID = @DESIGNATIONLEVELID;