InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:51:27 GMT20http://www.sqlservercentral.com/Forums/Topic1404693-391-1.aspxActually the SP is calling one more SP, in that sp we have used the same temp table.Thank you,Fri, 18 Jan 2013 00:30:58 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1404693-391-1.aspxPost the code of the stored procedure. Without it, the best folks can do is guess.Wed, 09 Jan 2013 06:14:09 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1404693-391-1.aspxhi All,I am facing a typical problem in my SP, actually the SP is using may temp tables. For better logic i have removed a temp table (#AggreTemp), when i see the Statistics IO of my SP that temp table(#AggreTemp) is still showing in IO. But the SP Is working fine. i have double checked that the "#AggreTemp" is used in the SP Or not, it is not in the SP.i have tried by clearing the Proc Cache FreeProceCache/DropCleanbuffers even it is showing in the Statistics IO.Please help me on this.Thanks,Wed, 09 Jan 2013 05:04:01 GMTSQL*