USP_DATAFORMTEMPLATE_EDITLOAD_PROGRAMREGISTRATIONINFORMATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@REGISTRATIONINFORMATIONTYPECODE	tinyint	INOUT
@REGISTRATIONSECTIONCODEID	uniqueidentifier	INOUT
@REGISTRATIONINFORMATIONID	uniqueidentifier	INOUT
@CURRENTREGISTRATIONINFORMATIONID	uniqueidentifier	INOUT
@REQUIRED	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROGRAMREGISTRATIONINFORMATION (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,

    @REGISTRATIONINFORMATIONTYPECODE tinyint = null output,
    @REGISTRATIONSECTIONCODEID uniqueidentifier = null output,
    @REGISTRATIONINFORMATIONID uniqueidentifier = null output,
    @CURRENTREGISTRATIONINFORMATIONID uniqueidentifier = null output,
    @REQUIRED bit = null output
) as

    set nocount on;

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = persri.TSLONG,

        @REGISTRATIONINFORMATIONTYPECODE = ri.TYPECODE,
        @REGISTRATIONSECTIONCODEID = pers.REGISTRATIONSECTIONCODEID,
        @REGISTRATIONINFORMATIONID = ri.ID,
        @CURRENTREGISTRATIONINFORMATIONID = ri.ID,
        @REQUIRED = [REQUIRED]
    from dbo.PROGRAMEVENTREGISTRATIONSECTION as pers
    inner join dbo.PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION as persri
        on pers.ID = persri.PROGRAMEVENTREGISTRATIONSECTIONID    
    inner join dbo.REGISTRATIONINFORMATION as ri
        on persri.REGISTRATIONINFORMATIONID = ri.ID
    where persri.ID = @ID

    return 0;