can anyone help me with this? I have to get things fixed this weekend and need to know how to do this.

Thanks in advance, Jim

thanks for the reply. Can you tell me how I do that with SQL2008 on WIN2008?

Jim

How would you ever get more than one row in the INSERTED table?

thanks,   Jim

Found the problem after talking to the vendor.  The application I am using to update the values, inserts a blank record then UPDATES the values.  My code did not look...