Update sql multiple columns select

Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 4 years, 4 months ago. Active 4 years, 3 months ago. Viewed 85k times. Improve this question. Andriy M Add a comment. Active Oldest Votes. FROM dbo.

ON tgt. Improve this answer. Andriy M Andriy M Your first result for two i. Sign up or log in Sign up using Google. Sign up using Facebook. Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. I am trying to update a table from a select statement but none of my rows are being affected. If I run the select statement I get results so I am not sure.

In the example I narrowed down the where clause. Any help will be appreciated. Based on the query you displayed, the syntax would look like :. As you mentionned that your queries were narrowed down, you might need to adapt the above example especially, you mentionned that you need to update 3 fields while you show only one in your code. How are we doing? Please help us improve Stack Overflow. Take our short survey.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Update multiple columns Table from a select statement Ask Question. Asked 3 years, 1 month ago. Active 3 years, 1 month ago. Viewed 3k times. My Select select a. Code, a. ItemGroup, a. Pack, a.