USP_DATAFORMTEMPLATE_VIEW_RESEARCHDETAILS_2

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RESEARCHDETAILS_2
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @RESEARCHSTATUSCONFIRMED bit = null output,
    @RESEARCHSUMMARY nvarchar(max) = null output,
    @RESEARCHGROUPLIST xml = null output,
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 1;
    declare @PROSPECTMANAGERFUNDRAISERID uniqueidentifier;
    select
        @DATALOADED = 1,
        @RESEARCHSTATUSCONFIRMED = PROSPECT.RESEARCHSTATUSCONFIRMED,
        @PROSPECTMANAGERFUNDRAISERID = PROSPECT.PROSPECTMANAGERFUNDRAISERID,
        @RESEARCHSUMMARY = PROSPECT.RESEARCHSUMMARY
    from dbo.PROSPECT 
    where
    PROSPECT.ID = @ID;

    set @RESEARCHGROUPLIST =
        (
        select * from dbo.UFN_GETRESEARCHGROUPSFORCONSTITUENT(@ID, @CURRENTAPPUSERID)
        for xml raw('item'), type,elements,root('RESEARCHGROUPLIST'), binary base64
        )

    return 0;