USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTPLEDGES_PRELOAD2
The load procedure used by the edit dataform template "Map Development Pledges Add Form 2"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SYSTEMID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @SUBTYPEONE | xml | INOUT | Pledge subtypes |
| @PDACCOUNTSYSTEMID | uniqueidentifier | INOUT | |
| @SUBTYPETWO | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTPLEDGES_PRELOAD2
(
@SYSTEMID uniqueidentifier,
@SUBTYPEONE xml = null output,
@PDACCOUNTSYSTEMID uniqueidentifier = null output,
@SUBTYPETWO xml = null output
)
as
set nocount on;
declare @ALLCODES uniqueidentifier = '99999999-9999-9999-9999-999999999999'
set @SUBTYPEONE = (
select @ALLCODES as SUBTYPEONEID
for xml raw('ITEM'), type, elements, root('SUBTYPEONE'), BINARY BASE64
)
set @SUBTYPETWO = (
select @ALLCODES as SUBTYPETWOID
for xml raw('ITEM'), type, elements, root('SUBTYPETWO'), BINARY BASE64
)
set @PDACCOUNTSYSTEMID = @SYSTEMID
return 0;