Just getting to see the people I depend on at work, talk with them, look them in the eye as we talk (and really in the eye, not looking either...

No, "Zero records" is not correct...

*** sorry for the spoilers; but my comment didn't make sense to me without them ***

I debated with myself between "Zero records" and the more comprehensive "Returns distinct rows from...

If it ain't broke - don't fix it.  So what if the legacy code doesn't follow some newly defined standard - or use the latest functionality available?  Unless that code...

Inconsistencies are a result of not having adequately defined and enforced standards. The reasons for the lack of standards is varying. While some rationale is sensible or a reasonable byproduct...

We need to think about why someone (admittedly, like myself) would make a habit of prepending the WITH statement of a CTE with a semi-colon. For me it's because I...

• This reply was modified 4 years, 4 months ago by Jason-. Reason: brevity

The analysis of how much time does an automation save vs how much time to build is important. I'd like to see more instances of that being used and it...

Continued Python then PowerShell and web technologies like HTML5/CSS/JS, nodejs etc. Then for technologies containers, cloud, git/github. I want to branch to postgresql and graph and document store dbs as...

• This reply was modified 4 years, 4 months ago by Jason-. Reason: brevity

I like the look and feel of ADS... did I hear someone say "dark mode"??!! Setting colors is more limited than I'd like but good enough for me and then...

• This reply was modified 4 years, 7 months ago by Jason-. Reason: Found new details to share

Question as is: I execute this code on SQL Server 2019. Each of the tables has one row in it. What happens?

DECLARE @SQL NVARCHAR(4000);

SET @SQL = 'SELECT...

This comment alludes to the expected correct answer so I put it in a spoiler block.

Either I misunderstood the question (which is likely here) or the below working code should...

In order to use one of the other data types we have to use a different type specification. While you can use all of those listed datatypes in RAISERROR you...

Of the list of types provided in the answer explanation, only CHAR, NCHAR, VARCHAR and NVARCHAR types will work.

All the other datatypes fail with the exception "The data type of...

And now as of 3.9.1

afc_west = a|b

Not trying to be the semantics police so I'll relinquish the stolen badge right after this, but since I struggled thinking this was a trick question I thought I'd share...

Technically,...