Click here to Skip to main content
15,884,176 members
Home / Discussions / Database
   

Database

 
GeneralRe: dbms_pipe Pin
mhmoud rawas15-Nov-03 18:36
mhmoud rawas15-Nov-03 18:36 
GeneralSQL get some ZERO's Pin
student()12-Nov-03 11:52
sussstudent()12-Nov-03 11:52 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 13:25
professionalJeff Varszegi12-Nov-03 13:25 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 13:55
sussstudent()12-Nov-03 13:55 
GeneralRe: SQL get some ZERO's Pin
student()12-Nov-03 14:27
sussstudent()12-Nov-03 14:27 
GeneralRe: SQL get some ZERO's Pin
Edbert P12-Nov-03 14:58
Edbert P12-Nov-03 14:58 
GeneralRe: SQL get some ZERO's Pin
Jeff Varszegi12-Nov-03 16:01
professionalJeff Varszegi12-Nov-03 16:01 
GeneralRe: SQL get some ZERO's Pin
student()13-Nov-03 3:35
sussstudent()13-Nov-03 3:35 
Yes this works:

SELECT IIF(ISNULL(Sum(Amount)),'0', Sum(Amount)) as 'Total Expenditures', '1' as 'Month'
FROM Expenditure
WHERE MONTH(eDate)=1


I suppose I will write it as Jeff suggested using the above.
Thanks for the help guys! THE CODE PROJECT IS AWESOME!
GeneralRe: SQL get some ZERO's Pin
Matt Gullett12-Nov-03 17:05
Matt Gullett12-Nov-03 17:05 
GeneralADO and DAO Pin
Anonymous12-Nov-03 4:41
Anonymous12-Nov-03 4:41 
GeneralRe: ADO and DAO Pin
Hesham Amin12-Nov-03 7:00
Hesham Amin12-Nov-03 7:00 
GeneralRe: ADO and DAO Pin
Tom Archer14-Nov-03 17:02
Tom Archer14-Nov-03 17:02 
GeneralIs Oracle really so much faster than MS Sql Pin
CillyMe11-Nov-03 22:21
CillyMe11-Nov-03 22:21 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Mike Dimmick11-Nov-03 23:49
Mike Dimmick11-Nov-03 23:49 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
CillyMe12-Nov-03 3:09
CillyMe12-Nov-03 3:09 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Bill Priess12-Nov-03 8:36
Bill Priess12-Nov-03 8:36 
GeneralRe: Is Oracle really so much faster than MS Sql Pin
Matt Gullett12-Nov-03 17:15
Matt Gullett12-Nov-03 17:15 
GeneralSql help Pin
pankajdaga11-Nov-03 11:57
pankajdaga11-Nov-03 11:57 
GeneralRe: Sql help Pin
Edbert P11-Nov-03 18:23
Edbert P11-Nov-03 18:23 
GeneralRe: Sql help Pin
pankajdaga11-Nov-03 20:35
pankajdaga11-Nov-03 20:35 
GeneralRe: Sql help Pin
jeff_martin12-Nov-03 7:44
jeff_martin12-Nov-03 7:44 
GeneralRe: Sql help Pin
pankajdaga12-Nov-03 21:42
pankajdaga12-Nov-03 21:42 
GeneralRe: Sql help Pin
jeff_martin13-Nov-03 3:36
jeff_martin13-Nov-03 3:36 
GeneralRe: Sql help Pin
pankajdaga13-Nov-03 10:15
pankajdaga13-Nov-03 10:15 
Generalaccess permissions Pin
ranjjj11-Nov-03 3:57
ranjjj11-Nov-03 3:57 

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.