Posted by --CELKO-- on 04/05/07 00:39

>> 'rec_id' is the primary key - I should have made that clear. <<

Yes, which is why the **minimal** Netiquette is to post real DDL. I
hope to Ghod you are not just numbering physical rows in your table
with IDENTITY or other non-relational crap. Can you share with us
what it means in your data model? How is it validated and verified?

If you have merely mimicked a sequential file in SQL, your data
integrity is gone.

[Back to original message]