USP_BATCH2_GETFORMOPTIONS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @BATCHTYPESPEC | xml | INOUT | |
| @DATAFORMINSTANCEID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_BATCH2_GETFORMOPTIONS
(
@ID uniqueidentifier,
@BATCHTYPESPEC xml = null output,
@DATAFORMINSTANCEID uniqueidentifier = null output
)
with execute as caller
as
set nocount on;
with XMLNAMESPACES(default 'bb_appfx_adddataformtemplate')
select @BATCHTYPESPEC = bc.SPECXML
, @DATAFORMINSTANCEID = dc.TEMPLATESPECXML.value('/AddDataFormTemplateSpec[1]/@DataFormInstanceID', 'varchar(36)')
from dbo.[BATCHTYPECATALOG] bc
inner join dbo.DATAFORMTEMPLATECATALOG dc on bc.ADDROWDATAFORMTEMPLATEID = dc.ID
where bc.ID = @ID
return 0;