USP_DATAFORMTEMPLATE_PROSPECTFUNDINGINTEREST_ADDLOAD

CREATE procedure dbo.USP_DATAFORMTEMPLATE_PROSPECTFUNDINGINTEREST_ADDLOAD 
(
  @PROSPECTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEREQUIRED bit = null output,
  @SITES xml = null output
) as
  set nocount on;

  set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

  declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
  if @USERSITEID is not null
  begin
    set @SITES = (
      select newid() ID, @USERSITEID SITEID
      for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
    );
  end

  return 0;