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