incomprehensible

Must be a language thing because you are missing the my point. Your data warehouse needs to capture that information that you are missing from your aggregate fact tables....

Really?? OMG. Now we have someone that can't even do simple math. :sick:

Simple math. Start with...

No, I'm not always answering with a question. But...

Cadavre (5/2/2012)

---

I'm going to take a bit of a guess, because so far you're not very clear.

This is ugly, needs to be tidied up and requires some performance tuning. ...

Almost PARTY TIME. SSC is getting close to 1,500,000 members! Currently at 1,498,547 .

First, we are all volunteers here, giving of our own time. If you have not gotten an answer it may be due to a lack of information or no...

I think I'd set max memory to say 4096MB. That would leave about 2GB for the OS.

Local System Account does not have access to network resources, iirc.

When providing the actual execution, instead of the XML version, save the graphical version as a .sqlplan file and attach that to your post.

blandry (5/1/2012)

---

Lynn,

In your second post you say "Thinking this is what you are trying get so far?" - uh, no... I dont get that many rows as shown in...

blandry (5/1/2012)

---

Lynn Pettis (5/1/2012)

---

Also, what counts are you trying to get. You provided the query you built the cursor on but you didn't show us what you were going...

And I'm just curious why. Other than curiosity, what is there you are trying to accomplish?

If you are that curious, have tried looking in Books Online? It is a very good reference for MS SQL Server.