Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Updating  three columns in temp table using a select statement

Posted on 2014-09-24
1
Medium Priority
?
266 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 143

Accepted Solution

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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

782 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