quote:

---

Originally posted by djs42

I'm attempting to update data in a SQL Server table that I'm importing from another application. I have multiple fields that I want to update.

Matching would be something like this:
UPDATE A
set A.Item10 = B.Item10,
set A.Item11 = B.Item11,
set A.Item12 = B.Item12,
...
set A.Item28 = B.Item28
WHERE A.Number = B.PartNo

How do I accomplish this in SQL Server?

---

UPDATE A set 
	A.Item10 = B.Item10,
	A.Item11 = B.Item11,
	A.Item12 = B.Item12,
	...
	A.Item28 = B.Item28
from 
	YourDestinationTable A
	inner join YourSourceTable B on 
		A.Number = B.PartNo

quote:

---

Originally posted by djs42

Tried this in a View in SSMSE, I get the Syntax error:

This SQL statement type cannot be used in a view or function.
Only a SELECT statement can be used.

Any ideas?

---