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

I don't see any web site at myblueguru.com.

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

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

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

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

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

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

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

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

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

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

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

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

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