@charles

Check this query out - I am sure this will be lot faster than your dynamic one AND this allows use of variables in the WHERE clause which do not...

@charles Eaton

Your SP is fine to use if you are using it for maintenance purposes. For transactional purposes, this is typical what you should not be doing.

I am quite surprised that someone thinks querystring based queries are faster than compiled queries.

Cliff - in your example, you will mostlikely have same performace as a compiled SP since...