Sure, We don't have any choice right now so i will run first stored proc and then i will try to run and compare the performance with your CTE.
I am agrred with that option as i like much better opposite to Loop.
Thanks for your help and Quick response!