USP_DATALIST_FAFREGISTRATIONBENEFIT

Provides the list of benefits for Registration type.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Event ID
@EVENTPRICEID	uniqueidentifier	IN	Event Price ID

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FAFREGISTRATIONBENEFIT(@EVENTID uniqueidentifier, @EVENTPRICEID uniqueidentifier = null) with execute as owner
as
    set nocount on;

    select EVENTPRICE.ID,
           BENEFIT.NAME,
           BENEFIT.DESCRIPTION,
           BENEFIT.VALUE
    FROM
    dbo.EVENTPRICE
    inner join dbo.EVENTREGISTRATIONTYPE on EVENTREGISTRATIONTYPE.ID = EVENTPRICE.EVENTREGISTRATIONTYPEID
    inner join dbo.EVENTPRICEBENEFIT on EVENTPRICEBENEFIT.EVENTPRICEID = EVENTPRICE.ID
    inner join dbo.BENEFIT on EVENTPRICEBENEFIT.BENEFITID = BENEFIT.ID
    where                         
    EVENTPRICE.EVENTID = @EVENTID AND EVENTPRICE.ID = ISNULL(@EVENTPRICEID,EVENTPRICE.ID)