Yes, this looks more like a running totals problem than a ranking problem.

Unfortunately, Jeff's article is still offline. You can get an idea of the process by looking at...

Ya, I know. That's...

Please do not double post. It just fragments any responses you may get regarding your problem.

Post replies here.

Thanks Roy and Gail. Guess being at the top for the last 30 days didn't last long though.

If there is anything you...

Thanks! 😉

Tom Brown (5/27/2009)

---

I have a very similar problem at the moment.

What I'm planning to do is add the linkedserver, then use OPENROWSET to select some data from the access database...

GSquared (5/27/2009)

---

Grant Fritchey (5/27/2009)

---

GilaMonster (5/27/2009)

---

I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and...

What?? If you are talking about your post, not sure if that truly answers my question. Is the OP using the SQL...

Have you tried reading about this in Books Online under the section on SSIS (SQL Server Integration Services)? That would be a very good place to start your research.

Question I have, is what day of the week does your week start on? Need to know that before we can tell you how to determine the starting date...

Jeff Moden (5/27/2009)

---

Damus (5/27/2009)

---

Jeff Moden (5/27/2009)

---

Why don't you just attach it to this thread so the rest of us can take a peek,...

Here is another OMG moment.

Kris (5/27/2009)

---

Sorry guys, but I don't know what sample data would do when it's wrong.....I want every customer that has bought a bicycle and every other purchase too.....if they haven't...

Totally separate rant, but the Dr. Pepper Company really upset me a while ago, they discontinued their Berries and Creme...