Non-CTE, non-APPLY version (2000 compatible?)

UPDATE RowsToUpdate

SET notional = ISNULL(new_value, 50)

FROM (

SELECT T1.value_date_minus_1,

...

Here's the non-CTE version:

UPDATE RowsToUpdate

SET notional = ISNULL(new_value, 50)

FROM (

SELECT T1.value_date_minus_1,

...

Oh for the love of small fluffy bunnies!!! :w00t:

You did see that this is the 2008 Forum, right?

Here is my final contribution,...

lmu92 (2/20/2010)

---

That's probably true (I trust your judgement 😉 ).

But if that would be the only CLR within all my databases I most certainly wouldn't use it, just because of...

But you definitely shouldn't! 😀

Setting ANSI_NULLS OFF can produce some very counter-intuitive behaviour. No wonder that it...

ChrisM@home

---

'Course it does, it's got a CROSS APPLY in it!:hehe:

CROSS APPLY is an awesome operator to use for compartmenting complex stuff for an output column without fear of changing the...

Even 'perfection' may be improved, perhaps...

WITH Data

AS (

-- This does the hard work of

...

At the risk of stating the slightly obvious, you will avoid all of these sorts of problems if you store date and time data in appropriate data types. Lord...

Re-using ChrisM's super test-data script:

DROP TABLE #temp;

GO

CREATE TABLE #temp

(

date1 DATETIME NULL,

date2 DATETIME NULL

);

GO

INSERT #temp...

Are you suggesting that a column with the...

Josh,

DBCC INDEXDEFRAG is another deprecated feature, and will be removed from the next version of SQL Server. You should use ALTER INDEX REORGANIZE instead.

Your example, as I am sure...

I suppose expanding the ranges could be expensive if the ranges are large.

The original posted question looks like a simple 'data island' problem to me, so we should be able...

It also occurs to me that you might be using 'text' from some past familiarity with Access. In SQL Server, text is one of the old large-object types, able...

See CREATE INDEX (Transact-SQL) for details. Here is the extract relevant to your current question:

---

Columns that are of the large object (LOB) data types ntext, text, varchar(max), nvarchar(max), varbinary(max),...

Wayne...