USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPLOCATIONHIERARCHY_PRELOAD
The load procedure used by the edit dataform template "Sponsorship Location Hierarchy Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPLOCATIONTYPECODEID | uniqueidentifier | INOUT | Type |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPLOCATIONHIERARCHY_PRELOAD(
@SPONSORSHIPLOCATIONTYPECODEID uniqueidentifier = null output
)
as
set nocount on;
select top 1
@SPONSORSHIPLOCATIONTYPECODEID = ID
from
dbo.SPONSORSHIPLOCATIONTYPECODE
where
ACTIVE = 1
order by SEQUENCE
return 0;