Hi,

I've considered this in the past, but not really been able to get it to work....

I considered that if you set up a DimDate as the 'time' dimension within SSAS,...

Yeah, I think that's the best option isn't it.. Try it out on a test installation.

Oh btw they want to upgrade to SQL2012 I'm just adding more ammo with this...

shame 🙁

thanks for the quick responses, much appreciated.

err.. thank you for being so terse? :hehe:

I guess the obvious follow up question is how the crap does checksum() work then? 😉

Cheers!

hi all, just thought i should follow this up with some detail in case anyone else needs to do something similar 🙂

big thanks to the guys that tried to help,...

um.. something i just realised, guess i must have overlooked this point when i replied to the thread at 2.30am 😀

after the first 45 days (which start date differs for...

Ninja's_RGR'us (5/13/2011)

---

Ok so you only need to process the new rows added today, but in a table with over 1 Billion rows? How many rows do you need to...

Ninja's_RGR'us (5/13/2011)

---

SOrry for the incomplete phrase... but you got the idea anyways.

How much data in this table (rows and gb in the table)?

Can we have the table definition including keys...

??

Ninja's_RGR'us (5/13/2011)

---

I can't help to think that there's more to it than what you're letting us know.

Maybe we can help rethink the whole process rather than...

just to follow up on this, yep it works a treat!

many thanks 😀

ahhhh, that looks like it should do the trick!

will let you know when i get to the office 😀

mucho thanks