Cool.  Thanks for the feedback.  Funny setting name, though.  I would never have thought to look under "Auto List Members".  Members aren't Objects.  Gotta love the lingo. 😀

That might also...

Heh... I'm no longer surprised by such things.  For example, the came out with EOMonth, which has the very problem we're talking about.  They didn't come out with an SOMonth...

A lot of things have changed in SSMS since it became a separate product and they continue to "ditz" with it and, so far, a lot of it has been,...

Apparently, the OP has left the building.

Thanks.  I'll look at it in a bit more detail later but my first impression is that the following line of code in the CROSSAPPLY is incorrect.

cast(dateadd(wk,datediff(wk,0,'01/04/'+iso.yr),0)+((iso.wk)*7)-1...

Is this still the best way to do this in 2021?  Google landed me at another SSC Forum from 2005, which I can't find anymore, and now I'm using...

I totally agree that "outlook, attitude, motivation and method" are incredibly important.  However, there have to be technical questions/discussions, as well.  I've found that they're actually important in me the...

This may seem insignificant in light of all of the decisions that need to be made about the future of events, but one of the things that was always...

Yep... that's the way it is... not the way it should be.  That's exactly what I'm talking about.  That junk methodology needs to be fixed.

If you post your data in a readily consumable format, you're more likely to get a coded answer for this.  Please see the first link in my signature line below...

IIRC, you have no control over backups and, if you want a single database to be restored, you have to request that the whole instance be restored.

Unless you want almost...

Instead of farting around with files, build a database to hold the error logs in tables and do something like what the fellow at the following link did.

https://www.mlakartechtalk.com/how-to-load-sql-server-error-log-into-table-for-analysis/

You could...

Totally agreed. ...

Jeff, what you describe is the essence of Agile Development, as it's done nowadays.

to fix the quality of software product the industry has to outlaw terms "agile", "sprint", etc.

You...

I've had many managers in the past 20 years.  Some were good, some not so good, and some were terrible.  The not-so-good ones can sometimes be "trained" through demonstration of...