I don't know if the original poster was asking about multi-dimension or tabular, but in tabular, all your hierarchy fields have to exist in the same dimension. A way to...

That worked perfectly and was exactly what I needed.

Thanks so much!!

Thank you all! I think part of my problem was Intellisense kept trying to add an additional single quote every time I tried to surround the single. So, if I...

I want to thank you both for your help. Unfortunately, I'm beginning to see that my company doesn't put data in audit tables the way I've been accustomed to seeing...

Ahhh!!! You're right. I was using the pre-bug-fix version. You are the best. Thank you again very much!

ColdCoffee, I missed a scenario. I really hope you can help me. The awesome code you wrote won't give me the correct results if the inmate moved back into the...

Thank you so very much! I will give this a shot when I get to work Monday morning.

I got it to work. The formatting is added by the cube, so we just needed to strip the formatting back out.

WITH MEMBER Measures.ActualSiteKey

...

Finally got it! I'm not sure if this is the best way, but it worked for me:

select CONVERT(NUMERIC(3,0),(CONVERT(int,SUBSTRING(Col4,1,CHARINDEX('%',Col4)-1))))/100

FROM Executive.StagedimWeight

WHERE Col4 IS NOT NULL

AND Col4 LIKE '%\%%'ESCAPE '\'

I am attempting to convert a varchar to numeric. However, I am trying to convert just a substring of the varchar.

I know with 100% certainty that this query only...

Are you saying I have to write it like we did back with SQL 2005? (Where you hard-code an "ALL" option that queries all?)

It turned out I just need to use the Join function in SSRS!

I was hoping to get a little advice regarding Sharepoint and I wanted to quickly “pick your brain.” On July 1, we’re upgrading from SQL 2005 to 2008R2 on our...

Wow...I feel really silly. It turns out I had inadvertently opened BIDS 2005 rather than 2008. I did not realize that it would keep the older version of BIDS. Should...

I upgraded my test box from SQL Server 2005 to 2008. It went smoothly. I then launched the "SSIS Package Upgrade Wizard" from SSMS. I pointed it at my SSIS...