A new line can be made of carriage-return or linefeed characters or both. So really you should be replacing both.

Try this:

REPLACE(REPLACE(REPLACE(ColumnName, CHAR(13)+CHAR(10), ' '), CHAR(10), ' '),...

WHERE AKey IN ('AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'GGG', 'JJJ') AND LEN(AKey) = 9

All the values in the IN have a length of 3. But you are...

;WITH cte AS
(
    SELECT x.customerid,
           x.stage,
        ...

No, as SQL 2000 did not have CROSS APPLY or selecting from VALUES or the datetime2 data type or ROW_NUMBER() or IIF or TOP.

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,...