Are these nested views, by any chance?

It would likely be helpful for you to provide some kind of reproducible example, as that'll help us understand what's going on. Can you perhaps post some DDL for some...

If you can supply the catapult I'm sure I can put the pork chops down as an "expense". 🙂

I'm not sure the strength will help me as it's likely to be...

As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years). I get the "fun"...

This does actually sounds like your data does have line breaks and/or carriage returns at the end of the data but you aren't seeing them. Perhaps you're copying the data...

Interesting. I hope they replace the original with this, but with full backward compatibility. I hate that -P is removed, though not sure security is changed if you need...

Honestly, I found one of early benefits of go-sqlcmd was that it has QUOTED_IDENTIFIER set to ON by default (unlike sqlcmd) and the -I switch (to enable Quoted Identifiers in...

Well there we go... There are no rows in your table (at least the sample data you've given) where your clause Transaction_Date = '2023-01-01' is true.

If your intention is not to help me, keep your negative comments and let those who want to help me, assist.

Dont, understand why the "trolls" on here want to...

So are you saying that you connect to the instance using a SQL login with Password, alter the Login to change the password, disconnect, then reconnect and it only accepts...

I'm not going anywhere near a stranger's Google Drive; I've no idea what sort of payload could be in there. Plus the domain is blocked at the office so strictly...

That would suggest that there is no data in your table [dbo].[Transactions]...

It seems like you don't want a running total here, just a windowed SUM. Remove the...

The value for running total looks correct to me. You're only returning the value of the first row, which means that the value of "Running Total" is actually the SUM...