You have written a script that if you run it twice you will get a different answer:

SET DATEFIRST 1
DECLARE @dayOfWeek int, 
     ...

If you go into menu item Tools/Options, you can change the value from 200 to a different number:

Or if you click the "SQL" button once you have...

• This reply was modified 5 years, 11 months ago by Jonathan AC Roberts.

You haven't shown the query you have written or the results you are getting.

SELECT t1.ID, t1.Name, t2.ValueA, t3.ValueB
  FROM Table1 t1
 INNER JOIN Table2 t2 
...

I think you can do the update with a single query, something like this:

;WITH CTE AS
(
    SELECT DISTINCT cdi_type,
     ...

Like Source control in TFS or GitHub

Why the extra step of replacing the concatenated CR and LF?  Doesn't replacing the individual CHARs suffice?  That's how I've done it, and I'd like to know if there...

The statement and what SQL Server does with it are two different things. SQL Server converts the CHOOSE to a bunch of CASEs and RAND() ends up being evaluated...

But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
   ...

But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
     ...

From the Microsoft BOL:

Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition....

Two single quotes together ('') is evaluated to be the same in an inequality expression as a space character [char(32)].

Couldn't you just use char(9) for your comparison instead of the...

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.