Thanks Mak for your suggestions


But i have a doubt. If i querry the database using the querry analyser it gives me the result in 0.00 secs. But if i happen to through the same results out by a asp page it takes around 10 seconds and some times more. I dont understand what is causing such a problem

thanks

shrenik