USP_DATAFORMTEMPLATE_ADD_PAPERLESSMANDATESSITECONFIGURATION_PRELOAD

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PAPERLESSMANDATESSITECONFIGURATION_PRELOAD
                    (
                      @SITEHIERARCHY xml = null output
                    )
                    as
                    begin
                      select
                        @SITEHIERARCHY = (
                          select 
                            SITE.ID as SITEID, 
                            (select 
                              PARENTSITE.ID 
                            from 
                              dbo.SITE AS PARENTSITE 
                            where 
                              SITE.HIERARCHYPATH.GetAncestor(1) = PARENTSITE.HIERARCHYPATH
                            ) as PARENTSITEID, 
                            SITE.NAME as NAME, 
                            row_number() over (partition by SITE.HIERARCHYPATH.GetAncestor(1) order by HIERARCHYPATH) as SEQUENCEFIELD
                          from 
                            dbo.SITE 
                          order by 
                            HIERARCHYPATH
                          for
                            xml raw('ITEM'),type,elements,root('SITEHIERARCHY'),BINARY BASE64
                        )
                    end