USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPPROGRAMADDON_PRELOAD

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPPROGRAMADDON_PRELOAD
                    (
                        @MEMBERSHIPPROGRAMID uniqueidentifier,
                        @BASECURRENCYID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        select  @BASECURRENCYID = BASECURRENCYID
                        from dbo.MEMBERSHIPPROGRAM
                        where ID = @MEMBERSHIPPROGRAMID

                        return 0;