USP_DATALIST_TRACKRESOURCEDETAIL

Returns all of the resources associated with the track..

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_TRACKRESOURCEDETAIL(@TRACKID uniqueidentifier)
                as
                    set nocount on;

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