Thanks Flo! That's exactly what I was looking for.

Another question, though. How can CPU time be greater than total elapsed time?

@madhu-2: it's not that the code doesn't work,...

Wow!

Thanks for taking the time out to write such a thorough explanation, Andrew!

I really appreciate it. Makes a lot more sense now. 🙂

Thanks again,

Goldie

dr_csharp (5/9/2009)

---

when i check this:

tools->option->Query Result->SqlServer

theres 2 item:

1.#result to grid

here maximum characters retrieved for xml data set to 2MB

2.#result to text

here,maximum number of characters displayed in each column set to...

andrewd.smith (4/30/2009)

---

Here's an alternative method that uses CTE's. It produces the same results as Wayne's quirky update given the OP's test data.

ConsumerFK ActiveDays

33 ...

TheSQLGuru (4/30/2009)

---

Goldie Graber (4/30/2009)

---

If your dates...

Amber.Brouillard (4/30/2009)

---

I'm not going to argue with you about this. I've been using dateadd(day, 1, date) for about six months and I use it in many different programs and...

If your dates have times with...

And please do not cross post.

Please continue replies on this thread: http://www.sqlservercentral.com/Forums/Topic705480-8-1.aspx

Aside from the fact that your posted code does not work, it seems that your JOIN condition is not correct and that is what's causing your problem.

Check out this code....

min.li (4/28/2009)

---

My previous post was actually trying to ask if cursor still has its use in certain circumstances. And to my particular case, it does weigh performance over scaling, and...

min.li (4/28/2009)

---

Thanks Samuel and Peter.

The real environment where this function to be used, the 'TestData' table is not really large. Or to be exact, the TestData table is large, but...

shashank (4/28/2009)

---

I've recently used CURSOR in one of my application (unwishingly though). We were working on a survey application and we collected the data of our web forms in our...

aaronxramirez (4/27/2009)

---

Just stepped in for a quick read up on the article...good article, however the examples are a bit naive and are not applied toward anything I would have ever...

@mark-3: Developers use cursors & loops because they are used to thinking procedurally and not set-based. They write loops because that mirrors their thought process.

@Barry: Awesome article! I...

Andy DBA (4/27/2009)

---

Goldie Graber (4/27/2009)

---

Thomas (4/27/2009)

---

Note that the comma-delimited list is sorted alphabetically. I'm aware that there is a hack using Replace, Stuff and For Xml to achieve this...