Viewing 15 posts - 16 through 30 (of 13,463 total)
to me it looks like a group by query will satisfy it.
SYMBOL TRADE_DATE Maxt1Level Mint2Level TheLevel
abc 2025-10-20 2.00000 2.50000 2.00000
and my query:
SELECT
t1.[SYMBOL],
t1.[TRADE_DATE],
MAX(t1.[LEVEL]) AS Maxt1Level,
MIN(t2.[LEVEL]) As Mint2Level,
ISNULL(MAX(t1.[LEVEL]), MIN(t2.[LEVEL])) AS TheLevel
FROM #nr_data...
October 21, 2025 at 9:11 am
I don't see any web site at myblueguru.com.
October 8, 2025 at 10:18 am
i think you might be running the command in an application other than SSMS/sqlcmd or a Sql agent job, right? a python/PowerShell/dotnet command could potentially create a sql command object...
October 1, 2025 at 12:39 pm
you can backup and restore, too and from an S3 bucket, will that help?
you need to set up a few things in rds first, and make sure of permissions on...
September 1, 2025 at 3:59 pm
i suspect you are missing part of a join statement, or have an incorrect logic in your trigger...like joining on parentId, but not ChildId. can you show the definition of...
September 1, 2025 at 3:51 pm
it's the service account that is running the SSRS Service that needs access.
You'll need to modify the Reporting Services Configuration Manager Subscription settings.
if the path is a unc path ,...
August 29, 2025 at 3:37 pm
just suggesting to check the basics...database mail has a dependency on dotnet 3.5, which is not installed in an operating system by default, and is easy to mis-remember the dependency....
August 27, 2025 at 1:20 pm
i think you may have toggled mixed mode authentication, but that setting requires a stop and start of the SQL service, as it is only loaded at that time.
it will...
August 20, 2025 at 1:44 pm
well dang. i found that SSC is scrubbing my posts if i paste the commands i previously used in linux.
i had a script in python that worked everywhere in windows,...
August 15, 2025 at 2:13 pm
so deadlock information is capture int eh system health extended event, in the stack of files it saves.
here's a really good stack of queries i put together and use on...
August 12, 2025 at 5:11 pm
here's an example i use pretty frequently. it's a stored procedure, that is calling Adam Machanic's sp_whoisactive.
if there are no long running transactions, It bails out gracefully, but if something...
August 6, 2025 at 2:00 pm
so as Johan mentioned, linked servers leverage tempdb. so if you are adding a WHERE or an ORDER BY, or joining it to your local data, the whole table goes...
August 5, 2025 at 1:45 pm
I happen to be in the middle of a vector project. i downloaded SQL2025, and while i can use the vector data type, the built in functions related to vectors...
July 30, 2025 at 8:49 am
I've been doing some stuff with the new [vector] data type as a result of some efforts related to AI projects. in both 2025 and Azure, the data type exists,...
June 20, 2025 at 2:03 pm
hey i found it. the sys.partitions has two new-ish columns xml_compression and xml_compression_desc
the code below is something i use for scripting indexes, but if i was scripting a table, i...
June 20, 2025 at 1:59 pm
Viewing 15 posts - 16 through 30 (of 13,463 total)