I have prepared and pitched the question based on AdventureWorks2012 sample database.

Question is for any solution to handle similar situation and not to optimize this or similar query.

If you still...

Ahh i got it .... there were few null rowguidcols which i have added after the update for testing

select rowguidcol, count(1)

from mytable

group by rowguidcol

having count > 1

Thanks for viewing.

Hi Grant Fritchey,

New machine, new installation of SQL2012 and restored the backups on new server

New client machine and new installation of SQL2012 client tools.

Its not quite often but still its...

The best help i found on this question is available on following Link. Thanks to Pavel Pawlowski. Excellent work.

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/1d00b9fd-80f9-493c-8d04-b125882a6e5c/#1d00b9fd-80f9-493c-8d04-b125882a6e5c

Thanks and Cheers.

Hi Moderator,

This is my second MDX question in "Analysis Services" forum of SSC and NO answer at all.

Am i on the right place for such questions? or what else?

Thanks.

Thanks everyone for your value input.

Thanks & kind regards.

http://stackoverflow.com/questions/5312493/in-ssas-cannot-make-the-parallelperiod-function-work-when-crossing-months-and-y

As mentioned in this link and in the following query, its working in the desired way. How to put this in Cube as calculated member?

SELECT

[Date].[Month of Year].CHILDREN...

opc.three (8/1/2012)

---

The EAV model is an anti-pattern when attempts are made to apply it as a 'more flexible' replacement to a proper relational design. There are certainly places where it...

Hi L' Eomot Inversé,

One thing you might have missed OR may be i could not understand in your reply is the flexibility for future enhancement.

For example:

In first approach, if...

Well Steve,

I don't like this at all.

But anyway, your site, your thinking, your decision....NP

Regards and Cheers.

Hi Ron (bitbucket-25253),

bitbucket-25253 (7/27/2012)

---

iBar

And as per moderator understanding and the points assigned to this question by SSC clearly means that this really worth it and this is what they also...

Well its not a time bound quiz, if you don't know the answer then no one forcing you guess it then and there.

That try to guess. As fluke can gives...

Hello Moderator,

According to BOL, 10 is the correct answer and 12 does not makes any sense.

Your team must monitor all such question before hand and suggest/make necessary amendments, where...

Nice one. Thanks Steve.

chaseurpuli (6/25/2012)

---

iBar,

Your script is of great help. Anyways, my data doesn't necessarily need to have just '.com' in the domain part. It may end with .net, .co, .edu ...etc. The...