petervdkerk (12/12/2010)

---

I want the statement to be flexible and if I later add columns to the database, I dont want to have to alter the query to include the newly...

LutzM (12/10/2010)

---

Unlikely. The tree is already occupied and I can't...

Have you registered the .dll as I first suggested?

Do you know what parameter the error message is referring to?

EDIT: This is an old thread, but it might be able to help you. http://www.bigresource.com/Tracker/Track-ms_sql-0kT9qz2f/%5B/url%5D

Ray K (12/10/2010)

---

crookj (12/10/2010)

---

Thanks...

Yeah, but...

LutzM (12/10/2010)

---

You get a table scan because your subquery has no limiting WHERE condition. In order to find max(Effective) per CoverageKey you'd need to scan the entire table (or clustered...

Horses don't feed themselves.

@=)

Copying .dlls may not be sufficient. Some of them need to be registered.

EDIT: Did you just copy stuff from the other machine or do you actually have SSRS installed on...

Management Studio allows for the creation of SSAS databases, but not the cubes themselves.

As far as processing cubes, I thought they only processed one at a time. But I never...

The relationships in my cube seem based on the DSV relationships I set up. When I right-click those lines, they give me the option of editing the DSV.

When you...

Sorry to hear that. Drink lots of hot liquids. That might warm you up.

Wasail.

As in I'm cooking up a batch tonight because it's finally "cold" for Florida. Been in the forties or thirties every night for about a week.

Yeah, I'm still not sure...

Anytime a webinar is "sponsored" by a company, there's twenty minutes of advertising at the end.

Didn't you know that?...