Click here to Skip to main content
15,903,856 members
Home / Discussions / Database
   

Database

 
GeneralRe: Access Query Pin
bgeroux15-Nov-03 6:31
bgeroux15-Nov-03 6:31 
Generaldbms_pipe Pin
mhmoud rawas12-Nov-03 18:30
mhmoud rawas12-Nov-03 18:30 
GeneralRe: dbms_pipe Pin
Mike Dimmick13-Nov-03 23:22
Mike Dimmick13-Nov-03 23:22 
GeneralRe: dbms_pipe Pin
mhmoud rawas14-Nov-03 20:01
mhmoud rawas14-Nov-03 20:01 
GeneralRe: dbms_pipe Pin
Mike Dimmick15-Nov-03 1:30
Mike Dimmick15-Nov-03 1:30 
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 
Does this work for you?

SQL
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   1                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=1
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   2                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=2
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   3                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=3
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   4                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=4
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   5                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=5
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   6                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=6
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   7                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=7
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   8                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=8
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   9                        as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=9
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   10                       as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=10
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   11                       as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=11
<br><br>
<font color="#0000FF">UNION</font>
<br><br>
<font color="#0000FF">SELECT</font> 
   <font color="#0000FF">ISNULL</font>(<font color="#0000FF">SUM</font>(Amount), 0)   as [Total Expenditures], 
   12                       as [Month] 
<font color="#0000FF">FROM</font> Expenditure 
<font color="#0000FF">WHERE</font> <font color="#FF00FF">MONTH</font>(eDate)=12

It's not the nicest way in the world, I admit. I'll let you know if I come up with a better solution. HTH.

Jeff Varszegi

P.S. You should join up-- membership's free, you know. That way you can get an email when somebody answers one of your posts. JKV
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 
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 

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.