USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPLOCATIONHIERARCHY
The load procedure used by the edit dataform template "Sponsorship Location Hierarchy Edit Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @SPONSORSHIPLOCATIONHIERARCHY | xml | INOUT | Hierarchy |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPLOCATIONHIERARCHY (
@DATALOADED bit = 0 output,
@SPONSORSHIPLOCATIONHIERARCHY xml = null output
) as begin
set nocount on;
select
@SPONSORSHIPLOCATIONHIERARCHY = (
select
SPONSORSHIPLOCATION.ID,
(
select
PARENTLOCATION.ID
from
dbo.SPONSORSHIPLOCATION AS PARENTLOCATION
where
SPONSORSHIPLOCATION.HIERARCHYPATH.GetAncestor(1) = PARENTLOCATION.HIERARCHYPATH
) as PARENTLOCATIONID,
SPONSORSHIPLOCATION.NAME + ' (' + SPONSORSHIPLOCATIONTYPECODE.DESCRIPTION + ')' NAME,
row_number() over (partition by SPONSORSHIPLOCATION.HIERARCHYPATH.GetAncestor(1) order by HIERARCHYPATH) as SEQUENCE
from
dbo.SPONSORSHIPLOCATION
inner join
dbo.SPONSORSHIPLOCATIONTYPECODE on SPONSORSHIPLOCATIONTYPECODE.ID = SPONSORSHIPLOCATION.SPONSORSHIPLOCATIONTYPECODEID
order by
HIERARCHYPATH
for
xml raw('ITEM'),type,elements,root('SPONSORSHIPLOCATIONHIERARCHY'),BINARY BASE64
),
@DATALOADED = 1;
return 0;
end