Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Vincent Rainardi Filtering Members based on their names from the set(MDX) RE: Filtering Members based on their names from the set(MDX)

  • June 3, 2010 at 9:41 am

    #1176043

    Hope this helps:

    CREATE TABLE #Dw(Color VARCHAR(20),[Revision Number] INT)

    INSERT INTO #Dw

    SELECT 'Black', 9843 UNION ALL

    SELECT 'Blue', 3970 UNION ALL

    SELECT 'Grey', (null) UNION ALL

    SELECT 'Multi', 3926 UNION ALL

    SELECT 'NA', 28919 UNION ALL

    SELECT 'Red', 4949 UNION ALL

    SELECT 'Silver', 3424 UNION ALL

    SELECT 'Silver/Black', (null) UNION ALL

    SELECT 'White', 568 UNION ALL

    SELECT 'Yellow', 4799

    SELECT Color,[Revision Number] FROM #Dw WHERE Color NOT LIKE 'b%' AND Color NOT LIKE 's%'

    /*Results:

    ColorRevision Number

    GreyNULL

    Multi3926

    NA28919

    Red4949

    White568

    Yellow4799 */

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]