>You still have to filter the candidate key on FOR !DELETED() if you use sorrugate keys.
>
>Therefore this problem does not have
Anything to do with the use of surrogate keys. You won't solve the problem with surrogate keys !! It makes no difference whether you filter the PK or the CK on FOR !DELETED().
>
>Walter,
You must have a very tightly controlled application to use indexes this way. What would happen in the event of a recall? (of a deleted record)
Crash?
MSCE, MCSP, Microsoft Channel Partner
Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?
Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.