Open SSMS.

Right-click the Databases folder in Object Explorer. One of the options is ATTACH. It should prompt you for file locations of the data and Log files

Do you mean a primary key?

did you not try attaching them? (Don't forget the log files).

Okay... having added a bunch of references about partitioning, read this one[/url] first... It's Gail Shaw's... (don't know why I didn't start there!). Be sure you understand what partitioning...

Is there a good beginner book on Multi-Dimensional / Tabular? I've been playing with DAX for a while (and I'm still terrible at it!)

Especially one that covers security/RLS.

Per Joey D'Antoni. About face, go back to Excel, upsize from there. There's a hack, but for what I'm doing, not worth the hassle.

Hi,

Welcome to SSC. Since you're new and your question isn't entirely clear, perhaps reading one (or both) of these articles will help us to help you.

How to post...

Where's the PARTITION BY Company part of your query? PARTITION BY is analogous to GROUP BY... and it seems to be missing, so the totals/counts won't "restart" when the Company...

First things first, since you clearly missed it.

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

If you post some consumable data, this probably isn't...

" even tho it will double the rows to load into the dim"... so? If you have a normal data warehouse, the number of rows in a dimension table...

Jeff,

I would but then I would lose the ability to drill into it. It's the smallest data warehouse structure ever! 3 dimension tables and a fact table. Not terribly...

What is being clicked on to bring up this menu? When I click the dropdown arrow next to my measure under the Values section, I get just two options: 'Remove...

I figured it out...

DIVIDE( [Symptom Count],

CALCULATE(COUNTROWS('Diagnoses'),ALL('Diagnoses'))

,...

any chance you can post the two tables... the T-SQL to create and populate them? Then it would be a lot easier to follow...

Not sure but you may need...

T-SQL Programming Part 9 - Using the MERGE Statement to Perform an UPSERT

Wait, the more I read your post, the less sense it makes. What are you REALLY trying...