By the way, the last 2 articles in Bill Pearson's link deal with cube storage and partition management. These may contain the info that you're looking for.

Not that I know of. It looks to be just instance level. This sounds counter productive considering the nature of Analysis Services and how it is file based...

By the way, this would entail you getting your data value into the pipeline as a column in the dataset. You could easily do this using the Derived Column...

Why not lose the variable declaration and pass in the 2 parameters like normal?

Update data.Table1

Set EndDate = ?

Where ID = ?

Right-click on the Analysis Services instance in SSMS, go to properties, and look at the DataDir property. This should correspond with where the files are on disk.

As...

Another thing I didn't mention is just ask questions. Don't be afraid to ask questions 'cuz that's how you'll learn. If you have cursors that you just don't...

Colder.

Overnight lows tonight to be between -20 and -25. That's straight temp, no windchill. I think my weekend project this week will be building an igloo in my...

itsmeman (1/8/2010)

---

That is a great example for how to accomplish something I described without a cursor.

Here we write cursors because it is pre-determined and believed that it keeps better...

Lynn, I think he is saying that both should have been corrected. I think this was an oversight in the example data.

Anyhow, here's a start. This will identify...

I would gladly trade my snow shovel for shorts and t-shirts. All of the snow and cold started here the day after I returned from the Bahamas. Back...

Great. We can go with using the first (lowest ID) as the valid ID. Now, one more thing that needs cleared up and I think Lynn touched on...

itsmeman (1/7/2010)

---

I have two rows for John Doe, they are the same person, the only thing that is different are the ID's. For John Doe he is listed 2x with...

The high temp tomorrow is -4. Overnight windchill lows of -30 to -40.

Any temperature that is positive and 2 digit would feel warm....

Well, not really. I see what you are saying, but I'm still not getting what makes a user ID valid. By the OP's definition,

A valid ID would...

First of all, thank you for creating the DDL, sample data, and desired results. This makes a HUGE difference when trying to help someone. You'll find that you...