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

I never had any exposure to SQL Server 2000, but my Google-Fu tells me you'll need to use DBCC SHOWCONTIG (see SQL SERVER – Comparison Index Fragmentation, Index...

Ooof on the Compatibility 80 level. SQL Server 2008 ran out of support back in 2019, so you really want to get that instance upgraded, but if you're still running...

Yes i had to do it that way then vendor wants the dates in a specific format and that was the only way I knew how to achive that......

• This reply was modified 3 years, 2 months ago by Thom A.

[TermDate] = CASE WHEN FORMAT(Termdate, 'MM/dd/yyyy hh:mm:ss') > FORMAT(HireDate, 'MM/dd/yyyy hh:mm:ss')
                ...

You've posted in the SQL Server 2022 forum, so we've been running under the (incorrect) knowledge that...

There are localization differences for the default code page when doing certain type conversions. I was wondered if collation is where that came from when a string is implicitly...