USP_DATAFORMTEMPLATE_VIEW_FAFEVENTSITES

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAFEVENTSITES
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @CURRENTAPPUSERID uniqueidentifier,  
    @SITES xml = null output  
)
as
    set nocount on;
  set @DATALOADED = 1
  select @SITES = (
         select S.ID,
           S.NAME,
           S.DESCRIPTION,
       (select PARENTSITE.ID from dbo.SITE as PARENTSITE where PARENTSITE.HIERARCHYPATH = S.HIERARCHYPATH.GetAncestor(1)) as PARENTID    
    from dbo.EVENTSITE ES (nolock)
  join dbo.SITE S (nolock) on ES.SITEID = S.ID
    where EVENTID = @ID
  order by S.HIERARCHYPATH
 for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64 )