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

Here's something close but not matching because maybe there's an issue with the example results?  Could you explain for LID='L005' and EID='E002' how ALLO='21.00' and DAYSS='6.00' and then the RL...

• This reply was modified 5 years ago by Steve Collins. Reason: Added ORDER BY and simplified query

A framework-ish way could be to use the awkward DATETIMEFROMPARTS and its 7 required parameters.

declare
  @today        [varchar](12) = '44:10:27.766',...

select c1.*
from #categories1 c1
where not exists(select 1
                 from #categories2 c2
 ...

These 2 queries produce the output you're looking for.  It should be said this is not a properly normalized data model.  There seemingly are "non-modelled" relationship(s) in the data which...

Nicely done The Dixie Flatline 🙂

What about checking @@rowcount?  This way 0 would only show up if there are no rows

SELECTCount(InvNo) AS RecordCount, BatchID
FROMBatchOrders
GROUP BY BatchID;
if @@ROWCOUNT=0
    SELECT 0,...

COUNT doesn't return 0 because you've also requested BatchID in the SELECT list.  The FROM clause is evaluated first and there are no rows.  On its own COUNT will always...

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

Ok, Category appears to not be a reserved word and appears in white.  Period and Value are both blue.  So it's brackets, no brackets, and brackets instead of brackets, brackets,...