USP_DATAFORMTEMPLATE_PRELOAD_AUCTIONPACKAGETOAUCTION

Parameters

Parameter Parameter Type Mode Description
@EVENTAUCTIONID uniqueidentifier IN
@EVENTAUCTIONNAME nvarchar(100) INOUT
@BASECURRENCYID uniqueidentifier INOUT
@TRANSACTIONCURRENCYID uniqueidentifier INOUT

Definition

Copy

                    create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_AUCTIONPACKAGETOAUCTION
                    (
                        @EVENTAUCTIONID uniqueidentifier,
                        @EVENTAUCTIONNAME nvarchar(100) = null output,
                        @BASECURRENCYID uniqueidentifier = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output
                    )
                    as
                    set nocount on;

                    select 
                        @EVENTAUCTIONNAME = EVENT.NAME,
                        @BASECURRENCYID = EVENT.BASECURRENCYID,
                        @TRANSACTIONCURRENCYID = EVENT.BASECURRENCYID
                    from dbo.EVENT
                    where EVENT.ID = @EVENTAUCTIONID;