?
Solved

SQL CUBES AND CF

Posted on 2001-06-22
3
Medium Priority
?
310 Views
Last Modified: 2013-12-24
Is there a way that you can hit cubes in SQL just like you would hit views or tables?

0
Comment
Question by:cat4larry
2 Comments
 
LVL 2

Accepted Solution

by:
hammond_david earned 100 total points
ID: 6221492
A cube is just a select statement with "with cube" in the group by clause.  What you probably want to do is take your select statement and create a view or populate a table with it.  Here's an example directly from my SQL Server manual:

SELECT SUM(units_sold), model, year, color
FROM automobile_sales_detail
GROUP BY model, year, color WITH CUBE

SELECT * FROM auto_cube

Hope that helps!
- David
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 10659277
No comment has been added lately, so it's time to clean up this question.
I will leave the following recommendation in the Cleanup topic area:

Accept hammond_david's comment as the answer

Please leave any comments here within the next four days.

mrichmon
EE Cleanup Volunteer
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question