SELECT MONTH(<THEDATE>), SUM(<FIELD>) FROM <TABLE>
WHERE YEAR(<THEDATE>) = 2004
GROUP BY MONTH(<THEDATE>)
Works in msSQL at least
Pieter
_____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24. november 2004 15:39
To: [EMAIL PROTECTED]
Subject: [development-axapta] Select statement and month
Is There a way in which I can made a select that select only the record
that in a Date field have a specific month?
select ct where MONTH(ct.myDate) = 2;
The problem is how can I build a select that sum a currency from a table
groupped by month?
Thank you.
Roberto Ukmar
Indis S.p.A.
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129rd3q7a/M=298184.5639630.6699735.3001176/
D=groups/S=1705006764:HM/EXP=1101394267/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=621297504>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
