To make the selection criteria specific to each column you could try a conditional aggregation approach to pivoting the data

select TestID,
      ...

This question still has me thinking.  How has development changed because of AI?  There's more than one trend happening at once imo.  For SQL the impact for me has been...

Thanks alot guys, I think I've taken a bit from each of the 3 posts and have made progress. I've posted the new execution plan below. Seems to be...

Disclaimer: this contains speculation and opinions

In broad terms, when considering performance, imo it makes sense to overlay the FROM clause with the execution plan.  The FROM clause is read left-to-right...

This query looks for the minimum previous appropriate enter_date for each row and then calculates the DATEDIFF.  The sample was expanded to include a greater than 12 month gap

            
January 11, 2024 at 4:25 pm
            
#4360334

            
            
                                                
        

"Gpt-4-1106-preview has training cutoff of 4/2022 and the context size is 16K (double the standard Gpt4)"  Oops that was not correct.  The cutoff for Gpt4-Turbo is 4/2023 and the context...

The company I work for has implemented ChatGPT 4 on its internal servers, actively promoting its usage among all employees. Given its deployment on company servers, there is also...

So you're ok with the loss of information assuming GMTOFFSET means what it appears to mean?  In SQL Server if you need to preserve the same information then you'd be...

Once a few years ago, at a prior job, I went on a sales engagement with one of our sales people.  At one point I got called into a meeting...

There's a huge disclaimer and warning associated with each of the items above.  Of course backup everything first.  There are also reasons NOT to do those things:

1. .vs is a...

VS does seem to get its signals crossed from time to time.  When things like this happen I close VS entirely and try the following:

1. delete the *.vs file in...

Nice one Drew.  CASE exits the expression once a true condition is found

I've used AI mostly for things outside of SQL development.  Like git and C# and Powershell.  It seems like it saves time (not always tho) and I go to Google...

Yes the current situation of set based development is quite conditional/permissional.  We're not at the final end state tho

I actually set the table option to have "large data types (LOBs)" be stored "out of row" (to prevent "trapped short rows" and other page density issues), which is...