Yes, using a temp table or union could be a good option. The SP probably can run better. However, this problem seems not the SP problem because the problem only happens few...

Thank you Journeyman.

I already change this stored procedure by using "truncate table SalesSummaryReport". I run it and didn't see any problem yet.

However, I still don't know why...

Thank you all for your replying.

Here is the sample code:

<%

'Connect the Database

Set Conn=Server.CreateObject("ADODB.Connection")

Conn.Open "DSN=Test;UID=sa;PWD=;database=Northwind"

'SQL Command

SQL="Select CategoryName, CategoryID from Categories order by CategoryID"

'run SQL Command

Set RS=Conn.Execute(SQL)

'Appear result

Response.write "<table Align=center border=1 ...