Please ignore... the solution provided itself works for this.. thanks

HI , Above code is like inner join... my scenario is more like left outer join... in below mentioned data, how...

Thanks a lot Eirikur Eiriksson

thank you so much everyone!.

Whole Idea behind the script is to find the performace gain in terms of execution time of two SPs...

SPone has set of queries...

SPone_Optimized is optimized version of SPone...

Thank you so much Jason!

Ok got it... Mod 10 using counter.. Thanks a lot Jason... I am storing the resultset into a temporary table in order to avoid 'out of memory' exception due...

Thanks Jason... by turning off the statistics i tried to execute the sp 5000 times... as it is 'select' SP , i am getting out of memory exception after some...

Thanks a lot sqlslacker...

Thanks Stewart... I would like to have cumulative execution time in order to compare the both SPs

Thanks a lot !!!!