USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@MEMBERSHIPPROGRAMID	uniqueidentifier	INOUT
@PROCESSPROGRAMSCODE	tinyint	INOUT
@TSLONG	bigint	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTSELECTIONNAME	nvarchar(100)	INOUT
@OVERWRITEOUTPUTSELECTION	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
                (
                            @ID uniqueidentifier,            
                            @DATALOADED bit = 0 output,                
                            @NAME nvarchar(100)=null output, 
                            @DESCRIPTION nvarchar(255)=null output,
                            @MEMBERSHIPPROGRAMID uniqueidentifier = null output,
                            @PROCESSPROGRAMSCODE tinyint = null output,
                            @TSLONG bigint = 0 output,
                            @CREATEOUTPUTIDSET bit = null output,
                            @OUTPUTSELECTIONNAME nvarchar(100) = null output,
                            @OVERWRITEOUTPUTSELECTION bit = null output
                    )

                as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @TSLONG = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = NAME,
                        @DESCRIPTION = DESCRIPTION,
                        @MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAMID,
                        @PROCESSPROGRAMSCODE = PROCESSPROGRAMSCODE,
                        @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
                        @OUTPUTSELECTIONNAME = OUTPUTSELECTIONNAME,
                        @OVERWRITEOUTPUTSELECTION = OVERWRITEOUTPUTSELECTION,
                        @TSLONG = TSLONG
                    from
                        dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
                    where
                        ID = @ID;


                    return 0;