I can't get my temp tables to work today and no-one in my team has a clue either! I have a main SProc which is creating the temp tables which I can then select from in the same SProc (so they are definitely there). I need to use them in another SProc called from the one that created the temp tables (EXEC @status_val=tc_stg_backdated_evts @debug=@debug) and it tells me that the temp tables don't exist. I can select from the main SProc again directly after calling the sub Sproc so what's going on? Happy to provide all SQL if that helps.
I see, that you are creating your tables in tc_stg_backdated_evts again in case when @trancount is zero - probably to make it work even when it's not invoked from tc_unstaging. I'm not sure, if it's possibe
Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!
Google always has something new and amazing up its sleeve, and the most current thing that they have been working on is another step in the evolution of Google Search, from machine learning to its brilliant successor, deep learning.
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions. Here are my tips for handling such a transfer.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …