USP_DATAFORMTEMPLATE_EDITLOAD_SITEHIERARCHY

The load procedure used by the edit dataform template "Site Hierarchy Edit"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SITEHIERARCHY	xml	INOUT	Site Hierarchy

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SITEHIERARCHY (
            @DATALOADED bit = 0 output,
            @SITEHIERARCHY xml = null output
          ) as begin
            set nocount on;                    

            select
              @SITEHIERARCHY = (
                select
                  SITE.ID,
                  (    
                    select 
                      PARENTSITE.ID 
                    from 
                      dbo.SITE AS PARENTSITE
                    where 
                      SITE.HIERARCHYPATH.GetAncestor(1) = PARENTSITE.HIERARCHYPATH
                  ) as PARENTSITEID,
                  SITE.NAME, 
                  row_number() over (partition by SITE.HIERARCHYPATH.GetAncestor(1) order by HIERARCHYPATH) as SEQUENCE
                from
                  dbo.SITE
                order by
                  HIERARCHYPATH
                for
                  xml raw('ITEM'),type,elements,root('SITEHIERARCHY'),BINARY BASE64
              ),
              @DATALOADED = 1;

            return 0;
          end