No, Jeff, I'm getting on another kind of error.

Your solution will work only in "Single-point real time event recording system".

Only such kind of system could guarantee that Identity order in...

You forgot

ORDER BY N

--------

BTW, your Tally table is an implementation of iteration step = 1 without hardcoding it.

See? It works!

The problem here is beyond of SQL. THe problem is in logic.

Those "bad" characters not suppose to be removed at all.

+44 means international code. It supposed to appear only when...

No, this is an error.

This will keep 50 last inserted records about some events, not records about 50 last happened events.

Feel the difference?

1) They tried. The reason I was asked for "ntext" function because "varchar" option did not hold the whole string supplied from application.

Surprisingly performance was quite good.

2) I put...

Jeff, there is a rule. Sounds a little bit bold but actually works.

If there is hardcoded value there is an error.

It does not mean I don't tolerate iteration step =...

Just posted the function here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=338231

What you need is a SP with single parameter. You'll supply all your values as delimited string to this SP.

Inside of SP you need to use special function to convert...

Actually trigger is stored procedure.

It's just invoked in another way.

I gave you a hint:

"Where have you stored list of "first" Items?"

You need to have "TOP 1" first, then you select "TOP 2" and return those from "TOP 2" which...

Where have you stored list of "first" Items (students), which are gone and not to be returned by your query?

If you have "any one" logic in place then same student...

I use to copy data from inserted to #inserted and from deleted to #deleted.

And if some nvarchar fields in table inserted must be trimmed I do it in this copy...

Why for Item4 and Item6 ItemNo = 2 is reported? Why not 1, not 3?

SP route will not stop from inserting more than 50 rows by another SP created by another developer.

Trigger is clearly the best option here.

But not INSTEAD OF, use just AFTER...

REPLACE function is for your service.

BTW, "+ 44 (0) 207... " must turn into "44207..." or "0207..."

That zero to be dialed only if you are calling from UK. And +44...