Click here to Skip to main content
15,881,709 members
Home / Discussions / Database
   

Database

 
Question"loop" this for me please Pin
nelsonpaixao23-Jul-08 13:40
nelsonpaixao23-Jul-08 13:40 
AnswerRe: "loop" this for me please Pin
Mycroft Holmes23-Jul-08 20:29
professionalMycroft Holmes23-Jul-08 20:29 
AnswerRe: "loop" this for me please Pin
BadhShah24-Jul-08 2:45
BadhShah24-Jul-08 2:45 
GeneralRe: "loop" this for me please Pin
nelsonpaixao24-Jul-08 12:10
nelsonpaixao24-Jul-08 12:10 
QuestionNested Aggregate Function Pin
Lash2023-Jul-08 9:56
Lash2023-Jul-08 9:56 
AnswerRe: Nested Aggregate Function Pin
TheFM23423-Jul-08 11:28
TheFM23423-Jul-08 11:28 
GeneralRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:53
mentorWendelius23-Jul-08 11:53 
AnswerRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:35
mentorWendelius23-Jul-08 11:35 
Hi,

If I understood you question correctly, you have several options. Few of those:

1. Create a query where you decide in which column you bring amount. Use CASE WHEN structure for decision and then use outer query to calculate sums and counts. For example
SELECT SUM(Cost), SUM(Sales), SUM(Amount)...
FROM (
   SELECT Cost = CASE WHEN n_codes > 5000 THEN Amount ELSE 0 END,
          Sales = CASE WHEN n_codes >= 4000 AND n_codes < 5000  THEN AMOUNT ELSE 0 END,
          Amount
          FROM...)

2. Use scalars for columns, for example
SELECT SUM(Amount),
       (SELECT SUM(Amount) FROM ... WHERE n_Codes > 5000 AND correlation to outer part if any),
       ...
FROM ...


Haven't tested those so there may be typos and such but they should give you the idea.

Hope this helps,

Mika
GeneralRe: Nested Aggregate Function Pin
Lash2023-Jul-08 12:23
Lash2023-Jul-08 12:23 
GeneralSQL Advice needed [modified] Pin
StevenWalsh23-Jul-08 8:22
StevenWalsh23-Jul-08 8:22 
GeneralRe: SQL Advice needed Pin
PIEBALDconsult23-Jul-08 8:51
mvePIEBALDconsult23-Jul-08 8:51 
GeneralRe: SQL Advice needed Pin
Ennis Ray Lynch, Jr.23-Jul-08 8:54
Ennis Ray Lynch, Jr.23-Jul-08 8:54 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 9:54
StevenWalsh23-Jul-08 9:54 
GeneralRe: SQL Advice needed [modified] Pin
Pete O'Hanlon23-Jul-08 8:59
mvePete O'Hanlon23-Jul-08 8:59 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 9:26
Graham Bradshaw23-Jul-08 9:26 
GeneralRe: SQL Advice needed Pin
Daniel Turini23-Jul-08 9:35
Daniel Turini23-Jul-08 9:35 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 9:41
Graham Bradshaw23-Jul-08 9:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 9:49
StevenWalsh23-Jul-08 9:49 
GeneralRe: SQL Advice needed Pin
Pete O'Hanlon23-Jul-08 9:52
mvePete O'Hanlon23-Jul-08 9:52 
GeneralRe: SQL Advice needed Pin
GuyThiebaut23-Jul-08 10:28
professionalGuyThiebaut23-Jul-08 10:28 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 2:41
SomeGuyThatIsMe24-Jul-08 2:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh24-Jul-08 4:40
StevenWalsh24-Jul-08 4:40 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 4:47
SomeGuyThatIsMe24-Jul-08 4:47 
QuestionCreating Reports using DataSet Pin
Reality Strikes23-Jul-08 5:19
Reality Strikes23-Jul-08 5:19 
AnswerRe: Creating Reports using DataSet Pin
Wendelius23-Jul-08 6:20
mentorWendelius23-Jul-08 6:20 

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.