>Ah, well I didn't mean to. I just copy and pasted in and it worked. Thanks
>Tim
>
You're welcome. I will be curious if you can compare 3 versions of the query: your original and 2 versions I posted and tell me the execution plans and percentage.
Put all 3 queries (after a correction to your original) into one sql script and run them
set nocount on
set statistics io on
set statistics time on
query 1
query 2
query 3
and post the results as well as percentage of execution time from the actual execution plan.
If it's not broken, fix it until it is.
My Blog