USP_DATAFORMTEMPLATE_EDITLOAD_DESIGNATIONANDAPPEAL

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DESIGNATIONANDAPPEAL(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 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
)
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,
    @DESIGNATIONID = AD.DESIGNATIONID,
        @APPEALID = E.APPEALID,
    @APPEALID_OLD = E.APPEALID,
    @APPEALDESIGNATIONS=dbo.UFN_APPEAL_GETDESIGNATIONS_TOITEMLISTXML(E.APPEALID)
  from dbo.EVENT E (nolock)
  left join dbo.APPEALDESIGNATION AD (nolock) on AD.APPEALID = E.APPEALID and AD.ISDEFAULT = 1
    where E.ID = @ID


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

    return 0;