Reference no: EM133022607
For this assignment, continue to play the role of the data analyst for Adventure Works Cycling Company. Your manager has asked you to localize query results into a temporary table to avoid running the same queries repeatedly and to better track the data. This will also free up network resources for the company. Saving queries is of the utmost importance since temporary tables are lost when you disconnect from the server. Failing to save a query will result in the need to rebuild the code for the temporary table.
Using the queries completed in the Topic 4 assignment, complete the steps below and address the questions.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy.
Need to create a Microsoft Word document that includes the SQL query code used to explore the database tables and answer the following questions.
1.Should be create basic temporary table from work done in Topic 4, question 5 and call it "MyTempTable." And write a SELECT statement to query the new data.
2.Order the results on MyTempTable by SalesOrderID.
5.Add a timestamp field called "DateRan" and update it to the current date.
4.Explain how to drop the table and start over.
5.Explain how the table can be re-added?