Here is my suggestion at this point, take the code you have been provided, and see if you can make the necessary changes to meet your new requirements. If...

Not really sure how this is going to help you, but based on what you posted, here is an answer as an attachment. Again, I seem to be having...

That is a good one! Thanks for the laugh on slow Friday!...

usman.tanveer (6/5/2009)

does that mean, it is not possible to break the Log sequence as...

You don't need to use AWE in the x64 OS/SQL Server environment. You do need to be sure set the maximum amount of memory that SQL Server will use.

Unfortunately anything we might say is simply guess work. You haven't provided us with the DDL for the table (including any indexes if defined), the insert statements you are...

Sounds like your database is using the full recovery model but you aren't doing any transaction log backups. What is your currnet backup strategy?

You could also give sswug.org a try, if you want to pay for membership. They seem to try and cover everything, not just MS SQL Server. They have...

Well, you actually have several problems. One, no select, insert, update, or delete using the CTE. Second, you have a group by query in the CTE with no...

What error? You didn't post the error.

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.