Great question, thanks.

Use window functions:

SELECT USERID, StartDate = MIN(DATES) OVER (PARTITION BY USERID, SET), EndDate = MAX(DATES) OVER (PARTITION BY USERID, SET)

FROM HOLIDAYS;

alicesql (4/22/2015)

---

Stewart "Arturius" Campbell (4/22/2015)

---

Good question, thanks Mark

alicesql (4/22/2015)

---

I need some help understanding this. When a table is created, the structure is defined. But no data exists in the table...

Nice question, but a bit of a limited explanation.

This article has more info:

What You Can (and Can’t) Do With Filtered Indexes[/url]

Nice question, thanks.

Great question. Not that I use recursive CTEs, but it's good to know 🙂

You try to burn him and...

Is it such a difference? I would expect that internally a MAX is implemented the same way.

manub22 (4/17/2015)

---

@Gail, sorry for responding to a 3yr old thread, and also attempting to promoting my blog post.

But it's NOT a SPAM as still this exam 70-461 is latest and...

From which tables are col1, col2, col3 and col4? Your sample query is pretty confusing because you didn't use aliases and you didn't put the aliases before the column names.

So...

Because you are promoting your blog post in so many threads, you are pushing...

Very nice question, thanks.

Small guess, but the title gave it away 😀

Hugo Kornelis (4/15/2015)

---

RLilj33 (4/15/2015)

---

On that note, I know that the ORDER BY clause is in general a performance killer. Can anyone speak to / point to a good article...

You are missing out a lot. 😉