USP_DATAFORMTEMPLATE_VIEW_RESEARCHDETAILS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RESEARCHDETAILS
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @PROSPECTMANAGER nvarchar(300) = null output,
  @PROSPECTMANAGERFUNDRAISERID uniqueidentifier = null 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;

  select
    @DATALOADED = 1,
    @PROSPECTMANAGER = MANAGERCONSTITUENT.NAME,
    @RESEARCHSTATUSCONFIRMED = PROSPECT.RESEARCHSTATUSCONFIRMED,
    @PROSPECTMANAGERFUNDRAISERID = PROSPECT.PROSPECTMANAGERFUNDRAISERID,
    @RESEARCHSUMMARY = PROSPECT.RESEARCHSUMMARY
  from dbo.PROSPECT 
  left outer join dbo.CONSTITUENT MANAGERCONSTITUENT
  on PROSPECT.PROSPECTMANAGERFUNDRAISERID = MANAGERCONSTITUENT.ID
  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;