Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
I don't know how to update a temp table with another temp tablefor example I have #tempdashboard that has info in it.I also have #tempappscount of which I want to insert the info inside it into #tempdashboardI believe the column in #tempdashboad isDailyAppsIn INT,I did a query that gave me the number of daily apps created. I was told to create #tempappscount and my query to dump into #tempappsaccount. Then dump the info from #tempappsaccount into #tempdashboard.Clueless but still trying to learn. Thanks
Lamprey
Master Smack Fu Yak Hacker
4614 Posts
Posted - 2013-08-19 : 16:46:34
The basci pattern for inserting from one temp table to another should be:
relatedcol is column(s) by which two tables are related------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs