Click here to Skip to main content
15,882,802 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: Nested Aggregate Function Pin
TheFM23423-Jul-08 11:28
TheFM23423-Jul-08 11:28 
Try using Case statements.

Example:
Select
Sum(Amount) as Amount
,Sum(Case When n_Codes > 5000 Then Amount Else 0 End) as Sales
,Sum(Case When n_Codes Between 4000 and 4999 Then Amount Else 0 End) as Costs
From ...
Join...
...


That should give you something to work off of.
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 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 4:47
SomeGuyThatIsMe24-Jul-08 4:47 

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.