UFN_BATCHEVENT_GETPRICES_2

Returns all prices for a given batch event record with currency.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEVENTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_BATCHEVENT_GETPRICES_2
        (
            @BATCHEVENTID uniqueidentifier
        ) returns table as
            return (
                select
                    BATCHEVENTPRICE.ID,
                    BATCHEVENTPRICE.EVENTREGISTRATIONTYPEID,
                    BATCHEVENTPRICE.NAME,
                    BATCHEVENTPRICE.REGISTRATIONCOUNT,
                    BATCHEVENTPRICE.AMOUNT,
                    BATCHEVENTPRICE.COST,
                    BATCHEVENT.BASECURRENCYID
                from
                    dbo.BATCHEVENTPRICE
                inner join
                    dbo.BATCHEVENT on BATCHEVENTPRICE.BATCHEVENTID = BATCHEVENT.ID
                where
                    BATCHEVENTID = @BATCHEVENTID
            );