Help with Update query

Question

Post reply

Help with Update query

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sql-programmers SSC-Addicted Points: 494 More actions · Answer 1

Yes your script will work for your situation.

SQL Sever Performance tuning

sk-458789 SSC Enthusiast Points: 188 More actions · Answer 2

Check out this....

update table1

set col2=B.col2

from table1 A, table2 B

Where A.col1 = B.col1 and A.col3>=B.col4 and A.col3<=B.col5

SKC

sap55 Old Hand Points: 322 More actions · Answer 3

Thanks everyone....Joe, thanks for the insight.

sap55 Old Hand Points: 322 More actions · Answer 4

Thanks for the reply CELKO!. How do you troubleshoot the following error message

Msg 8672, Level 16, State 1, Line 1

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

Is there a similar functionality available with SSIS? Thanks.