Please see this thread: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

Please see this thread: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

If you read the documentation about LIKE (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15) you will see that it does not support regex the way you are trying to use it.

For the OP.  I spent some time looking at the execution plans and the code you posted.  I have come to the conclusion that there just isn't enough here for...

edit:  Wrong post.

• This reply was modified 5 years, 6 months ago by Lynn Pettis.

There are proprietary temporal functions for formatting dates and working with them. Your code will never port to another SQL product. For example, the ANSI/ISO standard SQL uses the...

May I be honest?  Comparing the two plans, the original view is better that the your rewrite.  Your rewrite, looking at the plan in SentryOne Plan Explorer timed out trying...

Not exactly what you mean by reset/delete,  reset can have a different meaning than delete.  If you are talking about deleting all the data from the table once a week...

• This reply was modified 5 years, 6 months ago by Lynn Pettis.

Look up the date function date_part.

That is a simple question to answer.  The reason it doesn't throw an error in the second query is because of how SQL Server works with subqueries.  Since you are...

That was going to be my exact question.......

Still curious as to WHY you were using CTEs to accomplish your task.  It was just as easily done using the tables themselves.  Compare the code below.

IF...

That was going to be my exact question.... or is...

May I ask why you are using CTEs in this manner when you could just use the tables themselves?

Or, put the CTE with the select that is calling it:

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)INSERT INTO ProductName ...

• This reply was modified 5 years, 7 months ago by Lynn Pettis.