It was defined in the previous posts as NVARCHAR(60). The destination column appears to be NVARCHAR(100) though.

I am going with NVARCHAR(100), just to be...

Pritesh,

The point of an indexed view is that it automatically keeps partial aggregations up...

My best guess...

DECLARE @data

TABLE (

[date] DATETIME NOT NULL PRIMARY KEY,

...

Thanks!

Alex Kuznetsov blogged about this recently, highlighting common code and some considerations to bear in mind. I don't necessarily agree with all the content, but I thought I should...

MERGE was new for 2008 😛

Demonstration code using EXISTS:

-- Test table

CREATE TABLE #Test

(col1 INTEGER PRIMARY KEY, data INTEGER NOT NULL);

-- A row...

Demonstration code using MERGE:

-- Test table

DECLARE @test-2

TABLE (col1 INT PRIMARY KEY, data INTEGER NOT NULL);

-- A row to UPSERT

INSERT @test-2 (col1, data) VALUES (1, 1);

SELECT *

FROM...

Wrap your code in [ code ] [ /code ] tags (remove the spaces within the tags there)

Click the 'IFCode' button in the editor (to the right of the Bold,...

Nothing to apologize for -...

I am unsure how your code relates to the requirement "The idea is that if the record being saved already exists, update the row, otherwise insert it."

You appear to be...

Matt Miller (#4) (2/15/2010)

---

NULL is not a value, so as such, NULL is neither equal nor not equal to any value. Unfortunately, that also means that it's not LIKE...

Both what? Query performance and server performance? :blink: :unsure:

The whole thread is about why a given query appears to run faster on...

Yes, I should have said 'interior case' in my earlier attempt to explain where the product key sticker is on my copy.

I'd like to help, but the question isn't quite clear to me.

If you post some example data to demonstrate, it might help me understand it better.

Hi Mr. Corgi 🙂

Thanks for taking the time to track down those helpful links. As a tip, if you wrap those in IFCode [ url ] and [...