Viewing 15 posts - 16 through 30 (of 5,094 total)
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...
April 21, 2023 at 3:35 pm
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.
April 19, 2023 at 2:33 pm
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...
April 19, 2023 at 1:18 pm
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...
April 19, 2023 at 1:11 pm
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...
April 18, 2023 at 3:16 pm
I ran the stored procedure and still nothing in the table "PrimaryAccountGroupTracking"
Still no data in this table.
That would suggest that there is no data in your table [dbo].[Transactions]
...
April 18, 2023 at 3:02 pm
Hello again,
I changed my query like this but the result of RunnigTotal are wrog
It seems like you don't want a running total here, just a windowed SUM
. Remove the...
April 18, 2023 at 10:33 am
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
...
April 18, 2023 at 9:40 am
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...
April 18, 2023 at 9:18 am
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...
April 18, 2023 at 8:57 am
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......
April 13, 2023 at 1:34 pm
[TermDate] = CASE WHEN FORMAT(Termdate, 'MM/dd/yyyy hh:mm:ss') > FORMAT(HireDate, 'MM/dd/yyyy hh:mm:ss')
...
April 13, 2023 at 8:20 am
i have sql server 2012 then how to write this in old syntex
You've posted in the SQL Server 2022 forum, so we've been running under the (incorrect) knowledge that...
April 11, 2023 at 4:40 pm
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...
April 11, 2023 at 3:45 pm
Are you saying that the collation impacts the formatting of the date? I haven't really used smalldatetime, that seems like a very microsoft accessy problem to have
The collation, no,...
April 11, 2023 at 2:45 pm
Viewing 15 posts - 16 through 30 (of 5,094 total)