As I said it's a cute way to do it. My first answer was foreachtable but Gail had come up with it... 😉

I don't see your data so I can't spot the issues. Here's how I'd debug this :

Using [salestype(else)] IN the query will tell you where you're "losing"...

Why don't you test. That's the only you'll know for sure and understand what's happening.

You'll sleep better at night once you do.

That will take you some work to get to work.

Script the code to delete the current oldest partition. Then modify is with dynamic SQL so that you can account...

Cute way of doing it without loops or sp_MSForeachTable

You may want to change the sampling rate.

Also keep in mind that this takes ± 30 minutes to run on my 18...

I am reading wrong? Looks like both count columns should have the same info?

Also the trick with CASE and any aggregate is to "reverse them" >>

SELECT SUM(CASE WHEN ConditionHERE...

calvo (5/3/2011)

---

You're right. I should revise my post to say "an easy way...".

The difference is a gui that could handle converstions if necessary.

The benefit would be that it is easy...

GilaMonster (5/3/2011)

---

Because I didn't notice and wrote a couple...

Well a job to delete the old partition.

Another job could create the next one.

I've read a couple times taht guys create like a couple extra years of partitions in advance...

calvo (5/3/2011)

---

easiest way without having to learn SSIS is to just use SQL Server Migration Assistant for Access v4.2. This has a wizard to walk you through migrating your access...

Why does it bother you? People read this from google today so it's still usefull!

Ya documentation would be nice... :w00t:.

Adam Bean (5/3/2011)

---

Many updates have happened to these objects ... while our documentation is still rather poor, visit the site in my signature if you want to review these objects...

TheSQLGuru (5/3/2011)

---

Came over the top on me, eh?? Oh, I yield to the...

Tx.