• 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