• Mike,

    unfortunately there is no such thing as "CROSS APPLY" in MS SQL 2000.

    _____________
    Code for TallyGenerator