UPDATE Statement to multiple columns

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

UPDATE Statement to multiple columns

Author

Topic

spitfire122
Starting Member

11 Posts

Posted - 2012-03-29 : 16:13:19

I need to perform an update to large # of records and multiple columns.

How would I write the syntax for this? I cannot use an INSERT statement... because the records already exist and only need a few columns values updated.

the new values are in a separate table as well.

update loss_mit.dil_history d
set title_ordered_date = dd.title_order_date
from
	RPT101.loss_mit.dil_vendor_import_data dd
	on d.loan_number = dd.loan_number
where
	d.loan_number = dd.loan_number
	and d.lien_release_vendor_id in(101,102)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-29 : 16:25:04

[code]
update d set title_ordered_date = dd.title_order_date
from loss_mit.dil_history d
join RPT101.loss_mit.dil_vendor_import_data dd
on d.loan_number = dd.loan_number
where
d.lien_release_vendor_id in(101,102)
[/code]

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources