I managed to get lucky.  I had just finished renovating my home office when the first lockdown happened.  So I was able to transition to working from home full time...

I find I end up documenting tasks and issues more to help future me than anyone else.  I've been with my company for over 10 years now and there's a...

pietlinden was on a decent track with the main report/sub report idea.  I've used it once before, the basic process is:

1. Create the SSRS report that will generate the form...

I see, I think an inner join would do the same job.

I can't see how your stored procedure is reusing a temporary table from another call....

I see, I think an inner join would do the same job.

I can't see how your stored procedure is reusing a temporary table from another call. It...

The UI displays the data...

I just started looking at your proc and the first bit of code:

--Create a temp table with the nodes & figures to execute
SELECT n.itemNum,...

I just started looking at your proc and the first bit of code:

--Create a temp table with the nodes & figures to execute
SELECT n.itemNum, 
 ...

I can't see how presence of existing TEMP table would cause a problem as

CREATE TABLE #ReportResults (dateStamp dateTime NOT NULL, dataInterval int)

would then fail.

longshot : But ... maybe...

I can't see how presence of existing TEMP table would cause a problem as

CREATE TABLE #ReportResults (dateStamp dateTime NOT NULL, dataInterval int)

would then fail.

longshot : But ... maybe it...

I'm having an issue with a database that I recently moved from SQL 2014 to SQL 2019 (Standard in both cases).  The users get data from the database...

Did you change the Compatibility Level when upgrading from SQL 2014? (e.g. from 120 to 150)

If so maybe try it back at 120 just as a test for this...

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists,...

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists, does the...

Last few statements in the stored procedure are:

--export results
SELECT * FROM #ReportResults  ORDER BY dateStamp

--clean up temp tables
DROP TABLE #ReportResults

If I add option (recompile) to the...