What is the best way to update a field in a row by another field in the same row?
I have a table1 where columns are: recid, field1, field2, field3 and recid is keyfield
Problem: for every record where field1 is like 'xx%' then copy contents of field3 into field2
Using Microsoft SQL server Management studio query I tried:
SET field2 = tbl2.field3
FROM table1 tbl2
WHERE tbl2.recid = recid and tbl2.field1 LIKE 'xx%'
I got an error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'REQ_MULTIVALUE'.
Any suggestions appreciated.