UFN_TRACKITEMRESOURCE_GETRESOURCES

Returns the resources for a track item

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRACKITEMID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_TRACKITEMRESOURCE_GETRESOURCES
        (
          @TRACKITEMID uniqueidentifier
        )
        returns table
        as return
            select TRACKITEMRESOURCE.ID AS ID,
                         TRACKITEMRESOURCE.RESOURCEID,
                         TRACKITEMRESOURCE.QUANTITYNEEDED,
                         RESOURCE.ISPERTICKETITEM
            from TRACKITEMRESOURCE
                inner join RESOURCE on TRACKITEMRESOURCE.RESOURCEID = RESOURCE.ID
            where TRACKITEMRESOURCE.TRACKITEMID = @TRACKITEMID