• Thanks Guys for the response.. But just want to know if there is a workaround for this issue using crossapply ?

    AS it is looping through all the records now ..

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman