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 time of execution...i have understood your point except that the usage of mod function... with what value should i find mod?.. it will be great if you give some more hint