Thanks for all the posts! We are using this instead of an identity column. We have been able to tweak our query; here is the fastest one that we have...

Thanks for the reply. It was a little slower than the one we had. We have found one a little faster than the first post.

Select top 1 B.CID from

(Select...