you probably have to use a temporary table and aggregate "manually" into
that to achieve your goal in X++
it will however be much slower (on a big table) to do so.
It is not so difficult to write connection statements for mssql & oracle
to retrieve the data regardless of back-end; you will probably have to
use a temp table to use the data in axapta anyway, but the DBMS engine
will do the "hard" work for you...
Pieter
_____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24. november 2004 16:54
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Select statement and month
I'm sorry but I'm asking if it is possible using X++ not using the dbms.
Thanks
>
>
>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/*ht
t
>p:/www.netflix.com/Default?mqso=60185400>
>
>
><http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=grou
p
>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]
i
>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 Links
>
>
>
>
>
>
>
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=1295s6789/M=281955.5600462.6665252.3001176/
D=groups/S=1705006764:HM/EXP=1101424083/A=2343726/R=0/SIG=12igajojh/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11013376838
49781>
<http://us.ard.yahoo.com/SIG=1295s6789/M=281955.5600462.6665252.3001176/
D=groups/S=1705006764:HM/EXP=1101424083/A=2343726/R=1/SIG=12igajojh/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11013376838
49781>
Get unlimited calls to
U.S./Canada
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1101
337683849781>
<http://us.adserver.yahoo.com/l?M=281955.5600462.6665252.3001176/D=group
s/S=:HM/A=2343726/rand=592736697>
_____
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.