USP_DATAFORMTEMPLATE_EDITLOAD_EVENTDATAASSIGNMENT

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTDATAASSIGNMENT(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
    @DEFAULTCONSTITUENTSITEID uniqueidentifier = null output,
    @DESIGNATIONID uniqueidentifier = null output,
    @APPEALID uniqueidentifier = null output,
  @APPEALID_OLD uniqueidentifier = null output,
  @APPEALDESIGNATIONS xml = null output,
  @HASREVENUE bit = null output,
  @EVENTID uniqueidentifier = null output,
  @SITEFILTERMODE tinyint = null output,
 @SITES xml = null output,
  @SITEREQUIRED bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = E.TSLONG,
    @EVENTID = E.ID,
    @DEFAULTCONSTITUENTSITEID = EX.SITEID,
    @DESIGNATIONID = AD.DESIGNATIONID,
        @APPEALID = E.APPEALID,
    @APPEALID_OLD = E.APPEALID,
    @APPEALDESIGNATIONS=dbo.UFN_APPEAL_GETDESIGNATIONS_TOITEMLISTXML(E.APPEALID),
    @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
      @SITEFILTERMODE = EX.AUTOMATCHSITEMODECODE
  from dbo.EVENT E (nolock)
  join dbo.EVENTEXTENSION EX (nolock) on E.ID = EX.EVENTID
  left join dbo.APPEALDESIGNATION AD (nolock) on AD.APPEALID = E.APPEALID and AD.ISDEFAULT = 1
    where E.ID = @ID


   select @SITES = (
      SELECT EAS.[ID], EAS.[SITEID], S.NAME
     FROM dbo.[UFN_EVENT_GETAUTOMATCHSITES](@ID) EAS
     join dbo.[SITE] S on S.ID = EAS.SITEID
     for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64 )

  if exists (select top 1 ID from dbo.REVENUE where APPEALID = @APPEALID )
    set @HASREVENUE = 1

    return 0;