I have to tell you that if you work with the right recruiter, you don't have to worry about AI HR bots, HR people, or whatever.  A lot...

If all you want is the ability to lookup and access your queries - then you might consider Azure Data Studio instead of SSMS.  That does allow you to...

Heh... I'm sometimes amazed at how people almost feverishly try to learn a whole lot of new stuff when they haven't actually learned to use the old stuff or even...

I avoid the PIVOT operator and instead use the ancient "Black Art" of CROSSTABs because of more flexibility, functionality and performance.

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-%e2%80%93-converting-rows-to-columns-1

If you want dynamic CROSSTABs, those are pretty easy, as...

Personally, I avoid the PIVOT operator like the plague. I prefer CROSSTABs for functionality, performance, and more.

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

I don't believe so.

No.  Not queries in the object explorer.  If they're stored procedures, view, or functions, then you'll see them in the object explorer.

Maybe somehow in a "project" but I don't "projects"...

Hi,

I'm trying to query the amount of minutes a column value stays below a threshold and then group it together

Im Selecting records with  Values <= 20 and then use...

So... here we are near the end of the year 2021.  SQL Server 2022 has just been announced, miracles of both hardware and software have and continue to occur, MS...

Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...

It would also be helpful if you posted the CREATE TABLE statements for the two target tables and attach a text file with the first 10 or so rows from...

On of the things that's bugging me about this is that you say that the first import is going to a single column table yet you have a field terminator...

I found an issue in the code you posted. You may try after correcting it.

Assign a length to the NVARCHAR in the following line of your code. If you'll...

Did that work for you?  "Enquiring minds want to know". 😀

Another possibility is if two files were merged.  If (IIRC) a "control Z" character is in the file, that signifies the end of the first file and it may not...