You just wrote custom code on the database side of the house by including INT and NVARCHAR(MAX)...

It reminds me a bit of the differences between VHS and Beta tapes.  Beta was the better of the two but mostly never got off the ground.  Python seems to...

TBH, I have an extreme dislike for all of the solutions on this thread, not because of how they were coded, but because such code was required to begin with. ...

Agreed... thanks for the comments and, Steve/Grant, thanks for the feedback.

😀

I'm going to add this QOD question to my "Litmus Strip" interview questions.  I wonder how may people...

It's valid JSON.  You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions

/* two OPENJSON's */
select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with...

+1 MILLION for including the NVARCHAR(8000) answer, Steve!  The results there are absolutely astonishing.  Lordy!

"Reco-sca-lepy" would be...

Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one...

It's not ALL the problem, but it's part...

Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one of my...

Gosh... I wouldn't blame the "current level of technology" for any such complaints that Steve has cited.  That's not the issue.

I've not used "File Table" but I want to say "Thank you" for taking the time to share what you're doing.  You've always been one of the "good guys" on...

ISNULL/COALESCE is not as clear as explicitly checking for NULL:

SELECT COL1,
CASE WHEN Table1.COL2 = 0 then 'ZERO'
WHEN Table1.COL2 = 1 OR Table1.Col2 IS NULL then 'ONE'
ELSE...

I know almost nothing of Tableau, so just a couple of thought-provoking ideas.

1. Couldn't you have the Tableau Timer check to see if an "ItsDone.txt" file contains a certain file...