erikpoker (11/8/2011)

---

Ok. This was a bit more complex than I first realized.

The job that will update our DM from the DW is not a full update.

It will only select a...

PaulB-TheOneAndOnly (11/8/2011)

---

Any particular reason not to use the actual FACT table as the center point of your datamart? After all related DIM tables are related to...

erikpoker (11/8/2011)

---

For the last option I was thinking about creating a SISS package to do the following:

Do row exist? -> (NO) -> Add row

Do row exist? -> (YES) -> Is...

Regular expressions! They are perfect for things like this. You can't use them directly in SQL of course, but they work fine in the application or CLR. For example:...

I do have to ask, though, just how much data changes every 20 minutes. Is it enough to warrant doing an entire fresh load each time? You may want to...

A few ideas:

You could consider creating a view with the same name and schema as your current DM table has, that just passes through the data from the DM table...

If you want anything that happened since the start of the previous calendar day, rather than during the previous 24 hours, you'll need to do something like:

DATEADD(dd, -1, DATEDIFF(dd,0,joindate))

Thanks for the catch Gail, not sure what happened with that URL tag! :unsure: (Although It might have had something to do with needing another cup of coffee...)

It sounds like your .shp file has invalid geometry in it. Where did you get the file? Do you have access to the person(s) who built the file, to see...

OK, I should have just directed you to this blog post by Gail Shaw to begin with, probably a lot easier to understand than my ramblings above and has good...

Well...the first thing I notice is that you're actually selecting from vw_PackageInfo; based on the naming convention I assume that this is a view, rather than a table. When SQL...

Without seeing the whole query and knowing something about the underlying table structure and data, it's hard to say...

That's great stuff Jeff! I love this forum, I keep learning better ways to do things. 🙂

@RDBMS I sure did, sorry! My bad!

Here's my first stab at it:

WITH BalanceDates

AS

(

SELECT CurMonthEnd, PrevMonthEnd, MIN(dt) AS FirstTranDate, MAX(dt) AS LastTranDate

FROM (

SELECT DATEADD(MM,DATEDIFF(MM, 0, dt), -1) AS PrevMonthEnd,

DATEADD(MM,DATEDIFF(MM, 0, dt)+1, -1) AS...