This is a simple example, and could be used if you know the phrase you are looking for. You could expand on it to be more dynamic. Others can chime...

In the end I used the straight forward use of a temp table to use as a selection source to update my 2 tables.

Thanks for all the info. 🙂

I have not used...

What I mean is SQLServerCentral has a great community,...

unfortunatly ether/or table that gets updated will remove them from the view.

Yea I used the view because I thought maybe I could update the two tables that way.

You know what the problem was, I was using references that were outside SQLServerCentral.

Reverse the updates?? Is there some tactick you refer to?

This was done to 1 test record in a test DB before I unleashed it on my live DB, if that...

That to was suppose to be two in that post you quoted me on. I edited that post to reflect that.

Anyhow here are the results...

View or function 'view_set_DispInvNoComp' is not...

Complete is part of a different table that the rest of columns.

View or function 'view_set_DispInvNoComp' is not updatable because the modification affects multiple base tables.

I do believe this was the first thing I tried, but was under the impression that even in the view I still could not update to (* typo here, I...

so...

I guess how do I do that, subquery the second update at the end of the first?

I added the view to the previous post.

I ran this as a test, and the first update made its changes and the second one did not, so I pose the...

I suppose some code is in order.

This was the state of the code before the weekend.

View

ALTER view [dbo].[view_set_DispInvNoComp] AS

SELECT Dispatch.Dispatch, Dispatch.Invoice, Dispatch.RecDate, Dispatch.Complete, DispTech.Status, DispTech.Complete AS...

Given the information that is recorded it seems to me it would have been more usefull to store the datetime just as that datetime, not date with zero hours, and...

This is why I need to combine the 2 fields. Unfortunatly this is a small time, industry specific database / software package. They split the time the way they did...