I finally had a decent bit of time to start working on this and went back through all of the comments to refresh my memory.  I first came across this...

I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect):

December 11, 2021 at 9:52 pm

#3962748

Thanks for taking the time to write this article, Kathi.

What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as is frequently...

why do other uses need to see who can login on a server? that is on its own a security risk and should not be...

I have another question, I have data with space before square brackets and after sqaure brackets when i run below example 1 statement returning NULL.  But in example 2...

why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by...

Scott's method is the method I'd use to extract the object name.

I do concern myself what the source of the name is an how it will be used later in...

why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by default.

If it...

To help others that...

Total SWAG on my part but NOT using parentheses for the "N" number is only allowed for SELECTs and they did that only for backward compatibility.  The correct syntax is...

Smell that?  {sniff}... smells like  a prelude to SPAM.

If you missed that about CONCAT_WS, you may have missed another fantastic enhancement they came out with 2017.  The TRIM function.  Most people give it the "yawn" because they think...

Thanks for your feedback on what you've done.  Can you provide expanded test data to demonstrate what you've done?

And, you've not avoided any joins like you said you wanted to...

Hello SSC,

I hope everyone is staying safe and healthy.

I am using SQL 2017 and I have over 17 million rows that I have to UPDATE. Obviously I have to...

I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.'  It forced me into...