USP_DATAFORMTEMPLATE_EDITLOAD_EVENTAUTOMATCHSITEPERMISSION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTAUTOMATCHSITEPERMISSION(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @EVENTSITEAUTOMATCHMODE tinyint = null output,
  @HIERARCHY xml = null output,
  @SITES xml = null output,
  @TSLONG bigint = 0 output
)
as
begin
  set nocount on;


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

      select
      @EVENTSITEAUTOMATCHMODE = EX.AUTOMATCHSITEMODECODE
  from 
  dbo.EVENTEXTENSION EX
  where  EX.EVENTID  = @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 )

  select
        @DATALOADED = 1,
        @TSLONG = TSLONG
  from dbo.EVENT (nolock) where ID = @ID
end