• subscribe
July 24, 2003 12:00 AM

August 2003 MDX Puzzle

SQL Server Pro
InstantDoc ID #39485

The number-one item in the main article shows how to find the top 10 single, female customers based on unit sales. How would you rewrite that example query to find the top 10 customers based on unit sales who aren't single and female? Can you do it without listing all three of the other combinations (i.e., single male, married male, and married female)?



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...