• Hi Jeremy,

    I agree with you if the OrderHeader table has no index created with IDENTITY column. But as a general rule, we always create clustered or nonclustered unique index.

    If no indexes available, Of course you have to use one of your statements. Then there will be slight performance problems but still the method is the winner.

    Dinesh Priyankara

    mcp mcse mcsd mcdba