USP_DATALIST_PROGRAMRESOURCESBYRESOURCE

Lists the program resources by resource.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PROGRAMRESOURCESBYRESOURCE
            (
                @RESOURCEID uniqueidentifier
            )
            as
                set nocount on;

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