Hi gregw_lists,

I have removed Max query and replaced it with the one below.

SELECT TOP 1 @UserDefinedSequenceNumber = UserDefinedSequenceNumber FROM ORDERS

WHERE UserDefinedSequenceNumber IS NOT NULL ORDER BY UserDefinedSequenceNumber DESC

Still there are...

Yes i did thought of a sql agent job, but want to know if this can be achieved by some kind of locking or something else. I want to keep...

Ooookkkkk... so why the heck do you need error prone sequence logic in a RBAR trigger if you have an identity column in the table? This makes no sense at...

-Can you tell me why this column is nullable in the first place ?

I can make it not null, but how this is gonna help?

Why don't you just put it...

I cant use Identity column to solve this because I will be having null values also in the column.

Thanks

Pankaj