Thanks for your reply. We have an application created by a third party vendor that has a relationship with a varchar field in a table that we own to a...

You can use a derived table. Like this:

SELECT

SUM(DerivedTableName.NumOfOccurences) SumOccurences

, COUNT(DerivedTableName.NumOfOccurences) CountOccurences

FROM

(SELECT somecolumn

COUNT(somecolumn) AS NumOccurrences

FROM sometable

...

Have you tried using derived tables in place of temporary tables? I use derived tables in SSRS and they work fine. Also, derived tables have lower overheads in comparison to...

Other queries seemed to work ok. I'm not sure of the answers to your other questions. We didn't check those, at least not that I'm aware of. Someone in our...

We released all locks, with no success.

Thanks for putting some time into this for me, David. We've fixed the table by rebooting the server. We still don't know what went wrong, but fixing it with a...

I have select, insert, update, delete and dri(whatever that means) on the table. I'm in the public and db_owner roles.

I get no error messages from trying to delete or truncate...