But it's easy enough to clean up.  Just REPLACE(REPLACE(@sql, '1=1 AND ', ''), 'WHERE 1=1', '').  So if there are additional conditions, you remove the 1 = 1...

You can run perfmon and get it to log chosen stats to a flat file or even a SQL Server database. But unless you have something in place and...

Declare @startdatetime datetime = '2019-09-01T07:00:00'
Declare @enddatetime  datetime = '2019-10-01T07:00:00'

;with cte as
(
    Select d.UserId, 
         ...

Declare @startdatetime datetime = '2019-09-01T07:00:00'
Declare @enddatetime datetime = '2019-10-01T07:00:00'

 ;with cte as
 (
     Select d.UserId, 
    d.StatusValue, 
  ...

select d1.UserId,
       d1.StatusValue,
       d1.UpdateDate,
       d2.StatusValue PrevValue,
   ...

Hi all,

Assuming that I have the phrase "All I want (for Christmas) is better (TSQL) coding skills (this year)."

And I want to remove the parenthesis and everything in between...

Without wanting to give away the answer, the script creates an empty table variable that it populates to generate a select.  So I would look at rewriting the entire script...

At...

If you drop an object then...

Test if the object exists first, if it doesn't CREATE the object with minimal functionality, then ALTER the object to have the full code you required.

use ...

If you load them into a staging table with the date stored as varchar, you can go through the date column looking at the maximum value of substring(date,1,2) and substring(date,4,2). Hopefully,...

The DDL and some sample data of the type of duplicates you want to move would be helpful.

I've found performance to be the biggest problem with a MERGE. If you can replace a merge with an update followed by an insert it will give about 60% better...

I hadn't read the information about the source table being on another database. A good way to go is to first copy the data onto a Staging table...

;WITH Data AS
(
    SELECT * FROM (VALUES
        (1, 1, 'Begin', CONVERT(datetime2,'9/29/2019 9:00:05.656 AM')),
    ...