USP_DATAFORMTEMPLATE_LOAD_EVENTISMULTILEVELPART
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @ISMULTILEVELPART | bit | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_LOAD_EVENTISMULTILEVELPART
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@ISMULTILEVELPART bit = null output
)
as
set nocount on;
set @DATALOADED = 1;
if exists (
select 1
from dbo.EVENTMANAGEMENTOPTIONS
where EVENTID = @ID
)
set @ISMULTILEVELPART = 1
else
set @ISMULTILEVELPART = 0
return 0;