1. How many times have you ever worked with anything that required an output of storage of any date earlier than 1900?  I can see people taking exception to that,...

So I have a new interview question. 😀

Given the following output:

And the following code that produced the output:

September 24, 2021 at 7:11 pm

#3932869

I agree that a "Best Practice" to prevent recompiles would be to move the creation of the temp tables to the very beginning but that's not likely to make a...

p.s.  I hate the double spacing this forum does with code.  It makes even well formatted code look like junk.

Over the years, and especially this last 18 months, it seems like the problem of calculating the Nth Occurrence of some weekday has come up over and over.  It always...

I tested it with a couple of different DATEFIRST settings.  It appears to work correctly now.

To me... no.  Even if you do that...

Ya know... the very least you could do is run that code through a decent formatter to get proper indentation the help with readability.

While I'm sure it's not the whole...

I've amended your code. I think this should be a few times faster as it removes the need for a tally of 7 week days and just calculates...

Heh... one good test result is worth a thousand expert opinions.  😀

Ok.  So what in the code uniquely identifies that code and ONLY that code?  Which DB_ID does it run against?  What is the USER_ID the code from the front...

Sure, it's above; I posted it years ago, when this q was first asked.

Actually I should adjust it again, you only need to calc the very first Friday, from...

Is it a stored procedure or ad hoc code or ???

Heh... keeping with the spirit of the question... 😉

Results;

Good lesson on basic troubleshooting.  Sorry I almost screwed that all up with my post about desk checking.