USP_DATALIST_TRACKRESOURCE

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_TRACKRESOURCE
                (
                    @TRACKID uniqueidentifier
                )
                as
                    set nocount on;

                    select TRACKRESOURCE.RESOURCEID,
                           TRACKRESOURCE.QUANTITYNEEDED
                    from dbo.TRACKRESOURCE
                    where TRACKRESOURCE.TRACKID = @TRACKID