UFN_TRACKRESOURCE_GETRESOURCES

        CREATE function dbo.UFN_TRACKRESOURCE_GETRESOURCES
        (
          @TRACKID uniqueidentifier
        )
        returns table
        as return
            select TRACKRESOURCE.ID AS ID,
                TRACKRESOURCE.RESOURCEID,
                TRACKRESOURCE.QUANTITYNEEDED,
                RESOURCE.ISPERTICKETITEM,
                RESOURCE.NAME as RESOURCENAME,
                RESOURCE.PERTICKETQUANTITY
            from TRACKRESOURCE
                inner join RESOURCE on TRACKRESOURCE.RESOURCEID = RESOURCE.ID
            where TRACKRESOURCE.TRACKID = @TRACKID