When dealing with untrusted data, you'll need to use things like TRY_CONVERT().  If it fails, it will return a NULL.  Then you can go back to the original data and...

Jeff, The "url" link to the excellent article at the beginning of this discussion isn't working. I believe it should point to https://www.sqlservercentral.com/articles/hidden-rbar-triangular-joins, but only you have the ability...

"Bump" to check for missing posts at start of new page.

Heh... turned out to be SPAM... took that out.

It was great to see...

As someone who will turn 40 (Hex) in 2 months, I am in the same position. I love my current job and hope it is my last before I...

@jeff Moden for what it's worth, I saw your original post both before and after your follow-up, without issue. I am NOT missing a Jeff Moden post. That's unacceptable....

I so wish they'd fix the paging and the other incorrect "landing" for posts, etc.  "Bumping" my previous post so that page 2 would actually show up.

Perhaps us dinosaurs actually have a brighter future than you might think.  There seems to be a new trend away from the cloud.  It kind of started when Musk moved...

Thank You Jeff,

Let me read thru it, mess around with some data, I will get back with some data if I get hung up.

I really appreciate the info, Thank...

From the same SO link you provided, see the following link.  Within that, look for an "It-Depends" header.  The first paragraph of that section has to underlined n0t-so-obvious links that...

Here's an introduction to what you need to do...

https://www.sqlservercentral.com/articles/finding-%e2%80%9cactive%e2%80%9d-rows-for-the-previous-month-sql-spackle-1

If you need more detailed help, we'll need some "Readily Consumable Data".  Please see the first article in my signature line below...

Lordy... I can't believe they didn't use a cursor or while loop, according to another article that appeared today.

I totally agree with Drew's post.  You haven't used an example that even comes close to justifying the use of such RBAR.  This could cause folks, especially beginners, to make...

I'm of the "strong opinions, loosely held" view. I want to stick with things until I see something new working better. Meaning not only is it performing/working/saving/etc. better, but...

Certainly learning your existing tools well is important. However, I think you should also be learning new skills and judging when they are useful. That means lots of tests.

For...