Click here to Skip to main content
15,905,683 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 0:01
professionalEddy Vluggen25-May-12 0:01 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 0:22
mvePete O'Hanlon25-May-12 0:22 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 0:25
professionalEddy Vluggen25-May-12 0:25 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 1:23
mvePete O'Hanlon25-May-12 1:23 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 1:28
professionalEddy Vluggen25-May-12 1:28 
QuestionCould anyone recommend an interactive application for mass data analysis? Pin
bestbird778822-May-12 16:24
bestbird778822-May-12 16:24 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen23-May-12 0:30
professionalEddy Vluggen23-May-12 0:30 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778823-May-12 20:56
bestbird778823-May-12 20:56 
Thank you for reply.
SQl lacks stepwise computation ablility, so It is not a ideal solution. What I mean about stepwise is:
1. In excel, I can write number "10" in A1 cell, then formula "=A1*5" in A2 cell. then formula "=A2+2" in A3 cell. A1->A2->A3, It's stepwise.
2. When I change 10 to 9 in A1, then result in A2 and A3 will changed automatic.
3. an example: a. to select out the 10 categories of best sellers b. as a further computation on the basis of result from a., to select out the top 20 products from each category, c. as a further comparison with that of the last year based on the result from a.
let's call SQL_A,SQL_B,SQL_C as SQL statements for a,b,c. when I changed SQL_A (for example change 10 categories to 9 categories ), I must change SQL_B and SQL_C. why? because SQL_B and SQL_C is based on SQL_A. that is, SQL_B may like:

with SQL_A as A

selet.......

Excel has another problem, It is too simple to process mass data analysis. for example, to compute the product whose annual sales values are all among the top 100.
data structure( sales table's fields): productID, time, value .
the sql solution is:
SQL
WITH sales1 AS (
 SELECT productID, YEAR(time) AS year, SUM(value) AS value1
 FROM sales
 GROUP BY productID, YEAR(time)
)
SELECT productID
FROM (
 SELECT productID
 FROM (
 SELECT productID,RANK() OVER(PARTITION BY year ORDER BY value1 DESC) rankorder
FROM sales1 ) T1
 WHERE rankorder<=100) T2
GROUP BY productID
HAVING COUNT(*)=(SELECT COUNT(DISTINCT year ) FROM sales1)

above code is hard to write in Excel.
So what I want is some like SQL + Excel, do you have some idea?
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen24-May-12 0:26
professionalEddy Vluggen24-May-12 0:26 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778824-May-12 16:53
bestbird778824-May-12 16:53 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen25-May-12 0:04
professionalEddy Vluggen25-May-12 0:04 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778827-May-12 23:16
bestbird778827-May-12 23:16 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen28-May-12 1:25
professionalEddy Vluggen28-May-12 1:25 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
jschell24-May-12 8:44
jschell24-May-12 8:44 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778824-May-12 17:14
bestbird778824-May-12 17:14 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Jörgen Andersson26-May-12 9:43
professionalJörgen Andersson26-May-12 9:43 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778827-May-12 23:24
bestbird778827-May-12 23:24 
QuestionConversion failed when converting the varchar value in SQLSERVER 2008 Pin
ChandrakanthGaddam22-May-12 5:47
ChandrakanthGaddam22-May-12 5:47 
AnswerRe: Conversion failed when converting the varchar value in SQLSERVER 2008 Pin
scottgp22-May-12 6:02
professionalscottgp22-May-12 6:02 
GeneralRe: Conversion failed when converting the varchar value in SQLSERVER 2008 Pin
ChandrakanthGaddam22-May-12 6:20
ChandrakanthGaddam22-May-12 6:20 
QuestionHandling big tables Pin
V.21-May-12 23:28
professionalV.21-May-12 23:28 
AnswerRe: Handling big tables Pin
Mycroft Holmes21-May-12 23:56
professionalMycroft Holmes21-May-12 23:56 
GeneralRe: Handling big tables Pin
V.22-May-12 0:01
professionalV.22-May-12 0:01 
GeneralRe: Handling big tables Pin
Mycroft Holmes22-May-12 14:15
professionalMycroft Holmes22-May-12 14:15 
GeneralRe: Handling big tables Pin
R. Giskard Reventlov22-May-12 6:26
R. Giskard Reventlov22-May-12 6:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.