Have you looked at my trigger code? It doesn't use MAX() and it is an AFTER INSERT trigger, not an INSTEAD OF trigger.

The inserts may be somewhat slower, but...

Here is my test code creating a trigger to handle realtime updates. Please note that I create the trigger after inserting and updating the initial test data first.

Unfortunately, I...

The first thing I'd like to emphaize is that having your clustered index on the ID column (identity column) is not necessarily the best idea. You also need to...

Please don't cross post.

Please post replies here.

Here is a variation using a CTE and the row_number() function. Not wanting to fight with it, I am just sending it up as a attachment as well.

Depending on how many of these values you may have in a row, I'd consider using the bit data type.

Alvin Ramard (6/4/2009)

You can get points quickly if you ask questions here...

J-F Bergeron (6/4/2009)

Hey Lynn, I've been trying to do...

Lynn Pettis (6/4/2009)

Gaby Abed (6/4/2009)

Was that Mr....

Gaby Abed (6/4/2009)

Was that Mr. Echo from...

For some reason, I can't post the code directly. Please see the attached file for something I hope helps.

Hello.. Hello .. Hello .. Seems we got an echo in this thread.

By the way, BOL (Books Online) is a great resource for just this type of question.

Oh, please tell me exactly what I need to do. I have NO IDEA how to look things up in BOL.

Try putting the name of your field where the sample data was put in the post above.