Reminder... STRING_AGG() wasn't available until 2017.  The OP posted in a 2016 forum.

@WebRunner...

And so there's yet another adage we can add...

"If you want something real bad... that's usually the way you'll get it". 😀

The fly in the ointment is... what does "done" actually mean and when will it come back to bite you?  "Done" is just another name for "Good Enough" and I've...

Yes... Steve Collins posted an example above.  You could also use multiple SELECTs with a UNION ALL.

From the Article:

---

I find that many of us that work in technology want a solution to be great. Often perfect. Computers are so good at following instructions...

Amen to that!

So I saw a while back that its possible with a case statement, because once this sql code is created it goes into a another software that parses basic...

Ok... so what is "Criteria 1" and "Criteria 2" to return 1 value or another?

Why did you delete your post?  If you fixed your own problem, it would have been nice to know what the problem was and how you fixed it. 🙁

Another "spam" post, probably generated by some desperate bot.  Here's a post on Reddit with the exact same wording from 2 years ago.

https://www.reddit.com/r/sysadmin/comments/krzdbo/sql_server_2012_standard_mediaiso/

It was also posted back in July here...

Spot on an same here.  Exceptions have been made (one fellow has to drive his kids to school at a certain time every morning and so is excused from...

Hi Jeff,

My required output would look like this

So within each category the sort dense rank is sorted by Date. But the sorting needs...

• This reply was modified 3 years, 5 months ago by Jeff Moden.

You sure it's a table and not a function or a view? A simple select on one table shouldn't place locks on a second table, even if there are...

Check out the picture of the banner. The ad and the search look like one object.

Foreign keys in the file. Good call Jeff. (I have not been active in...

What is the actual character? What does UNICODE(RIGHT(ColumnName, 1)) return? That diamond character is the unicode Specials replacement character U+FFFD: If that actually is the value stored, then...