First question that has to be asked : Does this all have to be in the same transaction-scope ? (on-line/realtime). Keep in mind, if the trigger fails, your sql-transaction also...

Consider it as an extention to "Identity"

from books online (BOL)

If an application must generate an identifier column that is unique across the entire...

also keep in mind when defining your parameters, the better you allign with your sproc-parameter-datatype or column-datatype, the better your commandobject will be served.

Tell the system what you know !

you...

- Can you try to execute the queries without the TOP-keyword (and order by) in the views ?

- Like you can see, maybe you would be better off by altering...

If I'm correct this issue has been mentiond at SSC-forum last week or the week before.

IF I find the thread, I'll add it

updated :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=265470#bm266005

first of all :

- ... FROM         dbo.eventlog

WHERE     (RIGHT(attributes, 4) LIKE '%55}')

will cause a table-scan ! because with the function no index...

FYI

check out http://www.microsoft.com/sql/downloads/trial-software.mspx

for an 180-days trial version.

With SQL7 you will have to use a #tempTB in stead of a declare @tb table !

It does not know tablevariables !

If you are only interested in the last...

So your TableA is dynamic ?

if not, write a query to perform your select, determine a maximum...

maybe you'll find it overhere :

http://www.microsoft.com/sql/prodinfo/features/default.mspx

just for the record, to tease a bit

SQL2005 way:

start with RyanRandall 's example ...