I'm having a problem updating a table and im sure its pretty ... You can use the UPDATE FROM syntax ...
stackoverflow.com