Thank you all for trying to help. The reason I am using an insert trigger is because the After Insert trigger produced the condition in the first place so I...

The statements below are the latest example of an insert trigger that I am trying to use. I am not using a stored procedure to insert the record. The...

Aarez,

That was exactly what I needed thank you.

Mark

Jim,

I believe the following is what you are looking for. Copy the Statements into Query Analyzer and run them against your data. The first SELECT statement is simply a check...