USP_DATALIST_RESEARCHGROUPMEMBERNOTES

CREATE procedure dbo.USP_DATALIST_RESEARCHGROUPMEMBERNOTES
(
    @RESEARCHGROUPID uniqueidentifier
)
as
    set nocount on;

    select 
        CONSTITUENTNOTE.CONSTITUENTID,
        CONSTITUENTNOTE.TITLE,
        NF.NAME,
        CONSTITUENTNOTE.TEXTNOTE,
        CONSTITUENTNOTE.DATEENTERED,
        CONSTITUENTNOTE.DATECHANGED,
    CONSTITUENTNOTE.HTMLNOTE,
    dbo.UFN_CONSTITUENTNOTETYPECODE_GETDESCRIPTION(CONSTITUENTNOTE.CONSTITUENTNOTETYPECODEID) as TYPE
    from 
        dbo.RESEARCHGROUPMEMBER
        left join dbo.CONSTITUENTNOTE on RESEARCHGROUPMEMBER.CONSTITUENTID = CONSTITUENTNOTE.CONSTITUENTID
        left join dbo.CONSTITUENT AUTHOR on AUTHOR.ID = CONSTITUENTNOTE.AUTHORID
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(AUTHOR.ID) NF
    where 
        RESEARCHGROUPMEMBER.RESEARCHGROUPID = @RESEARCHGROUPID
    order by CONSTITUENTNOTE.DATECHANGED desc