USP_DATAFORMTEMPLATE_ADD_PATTERNBLOCKMEETINGS_PRELOAD

The load procedure used by the edit dataform template "Pattern Block Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PATTERNID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@USEPERIODS	bit	INOUT	USEPERIODS
@TIMETABLEID	uniqueidentifier	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PATTERNBLOCKMEETINGS_PRELOAD
                    (
                        @PATTERNID uniqueidentifier,
                        @USEPERIODS bit = null output,
                        @TIMETABLEID uniqueidentifier = null output
                    )
                    as

                    set nocount on;

                    set @USEPERIODS = 0;

                    select @USEPERIODS = case when TIMETABLE.SCHEDULETIMECODE = 0 then 1 else 0 end,
                    @TIMETABLEID = TIMETABLEID
                    from dbo.PATTERN
                        inner join TIMETABLE
                            on PATTERN.TIMETABLEID = TIMETABLE.ID
                    where PATTERN.ID = @PATTERNID

                    return 0;