SQL UPDATE using a view

[Shrimpersfan]

Hi there I am trying to update a field in our contact table. I have a view which contains all of the contacts that i need to run the update for, my question is:

 

How do i update a contact table but only update the contacts that are in my custom view?

[powdarrmonkey]

You need a JOIN clause.

[Pashers]

Hi there, you might want to look at something like:

 

Update TableName Set FieldName = CustomView.Field 
From TableName
Inner Join CustomView on
TableName.PrimaryKeyField = CustomView.ForeignKeyField

[pauljonze]

If all columns are the same I'd use something like:

 

select *

from (select * from old_data_table_name)

union

select * from new_data_view_name)

into temp_data_table

 

drop old_data_table

 

select *

into old_data_table_name

from temp_data_table

 

drop temp_data_table

 

Bit rough and ready because you're creating a new table of contacts and need to drop the old contact table but it works...