I suspect this bit of code in Query 2 is the reason:

and stcyt = '201110'

Oh and while you are at it, you might want to apply the same approach to your other IN statements...

Also, http://www.sqlservercentral.com/articles/T-SQL/73838/

You can't put a list (2011, 2012) into an int!

If you want to select multiple years, you will need to look at changing your stored proc to accept a varchar...

Ninja's_RGR'us (6/27/2011)

---

mister.magoo (6/27/2011)

---

Ninja's_RGR'us (6/27/2011)

---

mister.magoo (6/27/2011)And the same thing re-written using a CTE - just to show an alternate way to format the code:

;WITH ToDelete AS

(

...

Ninja's_RGR'us (6/27/2011)

---

mister.magoo (6/27/2011)And the same thing re-written using a CTE - just to show an alternate way to format the code:

;WITH ToDelete AS

(

...

SQLkiwi (6/26/2011)

---

One can delete 9 rows non-deterministically with this code:

DELETE TOP (9) @t

Though in practice you're likely to see the same 9 rows deleted, it's just not guaranteed. To...

Do you have a backup that contains the problem table?

It would be worth restoring that somewhere to perform some more tests.

I think standards are important, but this section made me giggle :

You get one and in a sentence. If you have more than that, or have an "or" or "but",...

How you cache it will depend on how much data there is.

You need to decide based on how much data there is to cache, how long you want to keep...

How about @Cpu_Busy or @Rowcount ?

It is because apple_id is valid, compare to this, which is equivalent:

CREATE TABLE #apples ( apple_id BIGINT )

CREATE TABLE #oranges ( orange_id BIGINT )

SELECT

*

FROM

...

Welsh Corgi (6/19/2011)

---

Have you tried what I...

Actually, I think the backup will stop that being useful - sorry - I did say I wasn't an expert - I think I will step aside on this one...

Do you mean you are executing this query many times per second/minute?

Are you using a connection pool? Is it possible that you are using up the connections in the pool,...