Hello, I am not sure where to start with this as I have never had to run report against a temp table before. I have wrote what I believe is a beautiful query to pull a ton of data into from MANY different tables to accommodate a request from administration. I then wrote a select query to pull in the data they need.
How do I set this up to run every day? I don't believe I can create the temp table right in my query written for the report in visual studio, can I? Do I need to set something up in SSMS for the temp table and then have the VS report run after the temp table is updated every day? Thanks