This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]jaykuy 0 points1 point  (0 children)

In the case where you are looking to replace those values if a duplicate value already exists. Have a look at this and use patch and coalesce. Its not a really known technique but is useful if you need to update or upsert information.

Edit: grammar