Lordy.  Thanks for the feedback on that.  It's very timely as I was going to...

While I agree about the culture part of that,...

You say you tested and nothing exceeded 6 characters in the source table.  If you use LEN() to do the test, you did it wrong.  Use DATALENGTH() instead and see...

Heh... this quote says it all about many situations...

"Lord give me patience because... If you give me strength, I'm gonna need bail money to go with it".

That's kind of what I'm talking about.  It's difficult for many people (especially managers) to understand that, many times, the key to increasing velocity and efficiency is to slow down...

You should read and understand the documentation on any functionality before you try to use it.

https://docs.microsoft.com/en-us/sql/t-sql/queries/top-transact-sql?view=sql-server-ver15

Heh... so many companies seem to have adopted the attitude of "We have to so something... even if it's wrong" and then they bitch about a slow release cadence with...

If you're going to split the data on the way in, even if it's just two columns, you're going to need a "Format File" to do it.  If no one...

Actually, Joe, I care very much about having a "corrected [sic] data model" and that's why I'm suggesting that having a NULL EndDate is the wrong way to do things. ...

Man... I followed the first link and clicked through a couple of links to get to the following...

https://docs.microsoft.com/en-us/sql/t-sql/tutorial-writing-transact-sql-statements?view=sql-server-ver15

I have to say (again) that I absolutely hate Microsoft documentation.  They...

Understood but many such "in-house-only" application and other data has been compromised both when someone gets into the nickers of your "in-house" domain and from "inside-jobs" done by less than...

It would be handy if you posted the links you found as clickable links instead of a graphic. 😉

Just like the other post, I'll remind you again that you need to tell management to get their act together and stop storing SSNs in clear text.  You will never...

That's why I don't use PIVOT code.  You should see the trainwreck when you need more than one PIVOT in the same query (for example: Qty and Amount for each...

Looking at what Frederico has done in code, I'd probably do it the same way IF the Promise Number and Location are unique within a row set group and that...