• subscribe
July 17, 2000 04:34 PM

August MDX Puzzle

SQL Server Pro
InstantDoc ID #9151

Suppose you're developing an application that must provide users access to large amounts of information, and you decide the best method is to display the data one page at a time (a page is 50 rows). If a user asks for unit sales to each customer during the four quarters of 1997, how would you write the query to return the first page of data? Remember, you want to return the customers in the order that they appear in the sales cube.



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 ...