Not too long ago there was a question for SQL Server 2012 with pretty much the same pattern.

https://www.sqlservercentral.com/forums/topic/how-to-make-pivot-to-feature-values-based-on-part-ca-and-x-exist-on-input-data/#post-3822116

Yes, no STRING_AGG in 2012.  We're in the 2016 Forum 🙂  To revert you could use STUFF+XML instead of STRING_AGG.

Not dynamic

select tmp_channel, tmp_entity,
       sum(case when tmp_category='Cat1' then tmp_charges else 0 end) cat1,
       sum(case when...

• This reply was modified 5 years, 4 months ago by Steve Collins.

A man goes to the doctor and says, "Doc, it hurts when I do this."  The doctor's response: "Don't do that."  What about not deleting the data within the transaction?

I think you're looking for something like this.  The first CROSS APPLY 'cma_check(cnt)' counts the number of commas.  The second CROSS APPLY 'wrd_check(cnt)' counts the number of words in the...

Yes I mostly agree with ratbak and I even narrowly agree with Joe.  If you've got access to pro software then use that 🙂  The code provided does sort of...

The query could split the input into left and right strings based on the location of the comma.  Then determine if the trailing character of the right string is a...

If the display order of the result set doesn't matter, using TOP(1) WITH TIES and ordering by the ROW_NUMBER

select top(1) with ties *
from #t1
order by row_number() over...

Regarding the specifics of trading scenarios it's just not my cup of tea.  If there was a specific SQL question (or answer) without any lingo then maybe.  But so to...

;with
loc_cte(loc) as (
    select distinct location
    from @tablom),
n(n) as (
    select n 
    from (values...

Thank you for your responses Rob.  It's an interesting story and your experiences with server code ring a bell which really resonates with me.  Ha, more could be said about...

So you think MONEY is a bad column for storing MONETARY values and that an INT which stores PENNIES (CENTS in US), is better. Is there a reason...