I don't know if there will be a good way to describe this in a post.

You need to add a grouping in your report on the District Manager. In...

You could use a pivot or a crosstab query (search for crosstab on this site and look for articles by Jeff Moden) but both require you to essentially hard-code the...

You can use an APPLY to do this pretty easily, but the performance will not be great because it becomes RBAR because of the correlated sub-query. If the data...

There is that NOLOCK query hint again...this hint should really be avoided, do you understand that it can not only cause you to read uncommitted data, but also miss committed...

...a good post and a bad one?...

Yes, server/CAL licensing does not care about the number of processors you have in the server.

I would suggest you go to the MS website and read about the licensing if...

Sorry:

lazy not 2 spell "PLZ"?

...and Steve, can we get the post button to reject anything in all caps and make the poster re-type it?

A merge join is usually fastest, but if you have a really large table and only need a few records, you really need to use a script component and query...

It is also pretty lazy to not even spell out "please"?

Open the cube in BIDS.

Select the cube structure tab (it's the default)

Right-click the measure in the treeview and select properties

In the properties window, change the FormatString property to: #.00

Save /...

Don't get too excited, setting up a SAN incorrectly can ruin performance. Make sure your SAN vendor helps you make good decisions.

As far as the configuration you are suggesting....

You either need 5 CAL's or a per-processor license (which will cost more than a server license and 5 CAL's).

They probably have BOL, I think they want someone to copy and paste just the relevant portions so they don't actually have to spend any time doing the work.

There you go doing something smart like clicking on the link.

Please turn off your caps lock.

If this is an actual measure rather than a calculated one, you need to go into the properties for the measure in BIDS and set...