Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: Creating a cube...and some ?'s

    1. Create a table. The table must contain four columns of your choice and at least ten rows. Create a meaningful example of your own. The last column in the table must be a quantity. Provide output showing your CREATE TABLE and INSERT statements. Also include output showing their successful execution.

    2. Create a ROLL-UP query using the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows. Next use the TRANSCT SQL help function of SQL Server and write definitions of the following SQL statements:
    a. IS NULL-
    b. GROUPING-
    c. AS-

    3. Create a CUBE query using the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows.

    4. Create the following CUBE queries using the table you created in problem #1. Provide output showing your SELECT statements and the resulting output rows.
    a. A CUBE query with Grouping used to distinguish Null values.
    b. A CUBE query showing a multidimensional cube.
    c. A CUBE query created using a view. For this problem you must not only create your view but query it and display the results.

    5. Create one example of a query using COMPUTE and one example of a query using COMPUTE BY. These queries should use the table you created in problem #1 Provide output showing your SELECT statements and the resulting output rows.

  2. #2
    Join Date
    Jan 2004
    Posts
    6
    I have no clue how to do this

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Sounds Like Homework to me .

    Better gear unp for some lashing from sundialsvcs
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jan 2004
    Posts
    6
    ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •