Martin,

Thanks for the link. It is good start.

As my tests showed, which hierarchy to use for a query-scoped calculated member is subjective. The query works regardless which hierarchy I pick....

I also tried creating a calculated member combining a member's status in two continuous months. So far I could not figure it out. This may not be feasible because the...

It is a repost of my code with formatting.

With MEMBER MEASURES.TEST AS

COUNT

(

NONEMPTY

(

NONEMPTY

(

[Member].[Member ID].[Member ID].MEMBERS,

(

[Status].[Status].&[Active], [Measures].[Member Count]

)

),

(

[Measures].[Member Count],

[Status].[Status].&[InActive],

[Month].[Year Month Hierarchy].CurrentMember.PrevMember

)

)

)

select

{

[Measures].Test

}

on columns,

{[Month].[Year Month Hierarchy].&[2015].&[2015Q1].&[201503]}

on rows

FROM [SnapshotCube]

Martin,

Your filter returns the union of March active members and February Inactive members, not the "intersection".

I use the following code to get the result. I feel it rather complicated but...

Martin,

Thanks for the quick reply

In the Advanced Tab, I still have to go through each attribute, right?

Also, I am trying to figure out how this "Advanced" Tab works. So far...

I think SSMS (the management studio) is just like any other software and needs update/fix/patch. Am I missing something?

To clarify, among the long list of SQL 2014 CU1, only...

So I will install the SQL 2014 CU1.

Thanks.

I've been using the script from this blog http://sqlknowledge.com/tag/ddl_database_level_events/ and have not got any issues.

Another good resource is:

http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/

Please note:

1. The DDL trigger is "After Event" trigger.

2. To catch all object...

My recommendation is to use SQL Server Data Tool. Its compile feature will detect any problems caused by changing one db object.

Thanks for all the help.

It works.

TextID NOT LIKE '%[^0-9]%'

Old Hand,

The link is exactly what I was looking for. Thank you.

I would use a persistent temp table rather than a table variable for your purpose.

Basically you need to clear the temp table, insert records, and then use Sean's function...

I am not what you meant by "ssis version".

Right now the only automatic way I can think about is to create s script task that output the full path of...

I use "Union All" in the code.

I looked deeper and saw there actually was a resource wait - PageIOLatch_sh. As far as I know, it is caused by large table...

Thanks for all the replies.

My test showed that, creating a view or sp in the user db does not work for me. With this approach, I have to assign the...