Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL CUBES AND CF

Posted on 2001-06-22
3
291 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
3 Comments
 
LVL 2

Accepted Solution

by:
hammond_david earned 25 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

809 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