USP_DATAFORMTEMPLATE_EDITLOAD_EventConstituentSite

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EventConstituentSite(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
    @DEFAULTCONSTITUENTSITEID uniqueidentifier = 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

    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

    select
        @DATALOADED = 1,
        @TSLONG = E.TSLONG,
    @DEFAULTCONSTITUENTSITEID = EX.SITEID
  from dbo.EVENT E (nolock)
  join dbo.EVENTEXTENSION EX (nolock) on E.ID = EX.EVENTID
    where E.ID = @ID

    return 0;