Thanks for your response Andrew,

I believe I found another way to take care of the problem I was having.

Using some of our internal tables to store the...

Have you thought of . . . to perform the update to the views manually by using a linked server and performing the update to the views using...

Sounds to me like you work for the Government.  As a current GE I can feel your pain. But the fact is the environment and culture in which we work...

Alex,

Your problem is with your delete SQL. You are most likely not deleting any rows because shipmentNumber can only be one value at a time,  try using OR's instead.

DELETE...

Have you thought of creating user views for them to use? 

We have a system that allows our users to query the data such as your talking about.

The back...