In SQL Server 2017 (14.x) and later, it is possible to use the TRIM (Transact-SQL) function:

;WITH ctePC
AS ( SELECT expression
   ...

Lets break this down into sets.

You are combining two sets of data from this table:

1. All Product rows where [product_id] > 2
2. All Product rows where [product_id] is 1...

The code is simple enough so why not do it in a UNION ALL between two queries to get rid of the "OR"?

WITH ctePC
AS ( SELECT expression
     FROM
       ( VALUES
        ...

I don't know but it sounds like the source of the files never deletes the old files.  With that, what are you doing about identical entries every time you run...

A friend of mine owns a bakery. His data needs are pretty simple, so in theory I could use Access (shudder)... It's basically Recipes, Recipe Ingredients, Ingredient Purchases, and...

I'm running thru folders where output from job processing happens and sometimes the product we use to run\schedule jobs doesn't detect and error condition even though the SP or...

This script works, but I would like to add a few more things to the process, and need some help.

1) Search multiple folders 2) Search for multiple strings patterns ...

This is what worked for me, but any rooms for improvement or suggestions is gratefully appreciated:

SELECT account, name, street, due_date FROM my_table WHERE CAST(CONVERT(VARCHAR,due_date,102) AS DATETIME) = (

case when...

If you use a SAN, check the SAN documentation for a "SAN Snapshot".  It's almost instantaneous.

You came down with COVID?  Sorry to hear and glad you're still around.  I know I sound like a Grandma but take...

I'll start off by saying that putting columns in functions in the WHERE clause is almost always going to cause full table or index scans and that's going to kill...

Heh.... must still be waiting for the first transfer to complete, eh? 😀

Ok... first of all, remember that none of the privs you established...

To be honest, I don't trust any of the estimates.  I've never had them be close for me.

I'm happy that everything eventually came back for you.  Sounds like you're having...