Hi Shawn,

You da man!!! Actually, I'm originally from New Zealand (been in the USA for 20 years), so I'm not sure that's the correct terminology, suffice to say that...

Hi Shawn,

Thanks very much for providing feedback on my issue. I didn't realize I was using a process that was not compatible with using a Switch like the one I...

Hi Steven,

Wow, thanks very much for the sample code! I'll try this out in my Virtual Environment this evening as well.

It's great, from my perspective, to get sample code that...

Hi,

I can see my priority reading after 15 years of SQL Dev neglect, is to make sure I have a thorough knowledge of the various types of joins again. Problem...

Hi Laurie,

Thanks for responding to my post! I think that might be what I'm after, but will try it out in my Virtual Envirnment to make sure. You can tell...

Hi Dwain,

Thanks very much for going to the trouble of setting this all out for me. I'm very new (well, very rusty after 15 years of non-use), to playing with...

Hi Gail, Jeff,

Gail: Thanks for the tip. Pivoting the data certainly sounds like what I am after. I'll take a look at that behavior.

Jeff: The result set...

Thanks Andy for your feedback.

The link that you provided was very informative. I hadn't come across that one in my research. The suggestions may also be helpful as I go...

Hi Andy,

Thanks for responding to my post. Actually, the IIS to Analysis Services piece of the puzzle is something that I don't have any problems with. I know that as...

Hi,

Thanks for the reference to this MS Article. However, I have already read through this article and while it describes in detail how to set up the "not cluster aware"...

Thanks Andrew,

At least that is a step on the right direction. Knowing that Analysis Services installed on its own box and pointing to a SQL Server Cluster works is very...