The two main methods are the CROSS APPLY (suggested by Piet) and the CTE/ROW_NUMBER (suggested by Sue and John). Given the density of the child table with respect to the parent table (642.125 [5137/8]), it's likely that the CROSS APPLY will perform better than the CTE/ROW_NUMBER approach, but you should test both. Both also require an index on at least the ResourceID.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA