Solved

Updating  three columns in temp table using a select statement

Posted on 2014-09-24
1
238 Views
Last Modified: 2014-09-30
Hi,

I am currently using a temp table to pull data to look through and work on. I would like to be able to update the temp table using a select statement or even better to be able to update the base table.

I have 3 of the columns in the temp table populated from the base table, col1, col2, col3.
 Col4, col5 and col 6 need to be updated with the results of the select. If possible updating the relevant rows in the base table would be preferable
Any guidance would be appreciated.
Thank you.
0
Comment
Question by:Morpheus7
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40341306
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now