USP_DATALIST_EVENTRESOURCE

Returns all Event Resource records.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_EVENTRESOURCE
            (
                @EVENTID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    EVENTRESOURCE.[ID],
                    EVENTRESOURCE.[RESOURCEID],
                    RESOURCE.NAME as [RESOURCENAME],
                    CASE
                        WHEN [RESOURCE].ISPERTICKETITEM = 0 THEN CONVERT(varchar, EVENTRESOURCE.[QUANTITYNEEDED])
                        ELSE ''
                    END AS QUANTITYNEEDED,
                    CASE
                        WHEN [RESOURCE].ISPERTICKETITEM = 0 THEN ''
                        ELSE CONVERT(varchar, [EVENTRESOURCE].[PERTICKETQUANTITY])
                    END AS PERTICKETQUANTITY,
                    RESOURCE.FORMATTEDPERTICKETQUANTITY
                from dbo.EVENTRESOURCE
                    inner join dbo.[RESOURCE] on dbo.EVENTRESOURCE.RESOURCEID = RESOURCE.ID
                where EVENTRESOURCE.EVENTID = @EVENTID