Click here to Skip to main content
15,877,591 members
Home / Discussions / Database
   

Database

 
JokeRe: Multiple databases from a master database Pin
SimulationofSai24-Jul-08 12:37
SimulationofSai24-Jul-08 12:37 
Questionacess database and bind to the datagrid using c# in ado.net Pin
swapnamoturu23-Jul-08 20:50
swapnamoturu23-Jul-08 20:50 
AnswerRe: acess database and bind to the datagrid using c# in ado.net Pin
Vimalsoft(Pty) Ltd23-Jul-08 23:37
professionalVimalsoft(Pty) Ltd23-Jul-08 23:37 
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 
Hello,

I was wondering if someone could help me with something SQL related. I'm trying to create a table that has the following granularity:

Client
Unit
Month
Year

I then want a few calculations at that granularity. The calculations are:

Amount
Sales
Costs

Amount is just a straight sum of the amount field in the existing table.
But to determine sales and costs I need to evaluate based on a n_code. So when the n_codes is > 5000 then Costs = sum(amount). When the n_codes is between 4000 and 4999 then Sales = sum(amount).

I do not want the n_codes in my output.
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 
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 

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.