Thanks for the replies.

No, no temp tables used.

Steve, I will try to set the alert, however, these deadlocks only occur under very high load, which typically only happens once or...

Hi all,

Thanks for the input.

Application roles: Don't want to do this, we are aiming for *really* thin clients, all business rules (including security) on back-end. Also, from what I have...

Sounds like a subquery...

Something like

SELECT <some fields>

FROM <some tables> as st1

JOIN (SELECT <some fields>

FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>

Now,...

Sounds like a subquery...

Something like

SELECT <some fields>

FROM <some tables> as st1

JOIN (SELECT <some fields>

FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>

Now,...

5409045121009 and whoteegan:

Thank you for the replies.

Raiserror in sproc #3 is handled correctly. No results are returned to the application, and the error message is displayed where expected.

whoteegan: Application not...

Sounds like a index problem, as in lack of useful indices. You don't mention any in your post.

Also, I'm not sure, but it appears that ExclusionList might not be normalized....

Not enough information to make a meaningful diagnosis: How do you know your query should execute faster? A 'simple' select statement on a 50-million row table with no indexes could...