Sorry Doc...I meant that specifically the different approaches to the "previous / next row" problem haven't been compared side by side.

As for Paul's Apply articles, I have read...

Thanks Chris...I guess it could be analogous to a non-equi join or a cross join with a where clause, but I remain somehow unconvinced and I'd still like to see...

Alistair,

Just looking at it, I'd tend to agree with you. While I agree with the assertion that the CTE approach can't benefit from indexes (there are none), I'd be...

Excellent article...pitched just right for me. Like some of the other readers, I found that it required a little effort to understand, but that was to do with the...

alistairgthomas (11/11/2010)

---

OK, confession time. Reading Charles' Outer Apply suggestion I can't see why this isn't a RBAR solution. Doesn't the Outer Apply do exactly what a subquery of the type...

Shouldn't you have a LEFT JOIN rather than an INNER JOIN?

The xml you are trying to create isn't valid.

You are on the right lines with your sql xml, but the problem is with your target.

<Is>

...

Jeff Moden (9/4/2010)

---

And did you see the size of the style sheet that was posted on this thread?....The addition of a style sheet in the discussion made it...

Hi Liya (aka anudata!),

Given the volumes of data involved, I suggest you get familiar with the other approaches available in tackling this problem. If you leaf through the discussion...

anudata...first point is that a lot of people won't answer your post because you haven't made the effort to script the data.

Look at how Eric did it above....

Protecting reputation is extremely important. The michigan example reminds me of an incident a couple of years ago where EUROSTAT, the European institution charged with providing statistics about everything,...

charles.gildawie (8/20/2010)

---

It's a good introduction for ROW_NUMBER but the query plan it generates is a little horrible. I wouldn't recommend ROW_NUMBER() for this task.

With the ROW_NUMBER() approach you can't use...

Couldn't agree more, Steve.

Two personalities in the SQL world, I'd most like to meet. Steve and Steve's wife!

In France, where I live, (and I wouldn't be surprised if it...

David McKinney (7/9/2010)

---

Thanks Mark,

Interesting idea and implementation. I think it's a pity you didn't put a little more text around it, add an example and submit it as an...

Thanks Mark,

Interesting idea and implementation. I think it's a pity you didn't put a little more text around it, add an example and submit it as an article rather...