Solved

SQL CUBES AND CF

Posted on 2001-06-22
3
287 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now