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...

Thank you for your qualified thanks, I think.  You've been on this site for a long time so ok maybe something like this is helpful.

declare
  @totalstake...

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

My apologies there was a mistake in the code.  You're correct there shouldn't be duplicates as you described.  In the 'xply_cte' CTE the 4th column contained an incorrect table alias. ...

It's not a good approach imo.  It's not necessary or polite to call anyone out.  For my part I'm not familiar with the terms and I'm generally uninterested in gambling. ...

• This reply was modified 4 years, 7 months ago by Steve Collins. Reason: Fixed column alias in CTE

You could maybe replace the whole WHILE LOOP'ing function with Eirikur's LEAD splitter.  If this is SQL Server 2016+ you could use the built-in STRING_SPLIT itvf (since the order...

The query could be simplified, no?  Maybe something like this

select top(1) p.AkcesAutoID
from dbo.podrobnosti p
     join ro.fntStringsToTable('J') ltrs on ltrs.EvidenceLetter = p.EvidenceLetter
  ...

Here's another approach which uses a tally function to row multiply the 'Amount' column value(s) for both credits and debits.  A similar approach to FIFO calculation recently won some...

[Edit] This is pretty much the same as Phil's code in the other thread with same name.

with improper_cte(FirstName, LastName, DOB, ID) as (
    select...

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

Instead of writing a query to do this crosstab would it be possible to go back to whatever code landed you at those 2 rows with different ID's in the...