________________________________
From: Unger, Denis [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 12:57
To: [EMAIL PROTECTED]
Subject: AW: [development-axapta] Order By And Group by in one while select Statement
Group by automatically sort your records so you don't need line "order by ...".
Denis
-----Urspr�ngliche Nachricht-----
Von: yifath1 [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 12. August 2004 12:13
An: [EMAIL PROTECTED]
Betreff: [development-axapta] Order By And Group by in one while select Statement
Hi All
I know this should work but it keeps telling me i have a syntax
error my code goes like this :
while Select Sum(lineamount) From Salesline
Group by projcategoryid
Order By projcategoryid
Where Salesline.createdDate >= FromDate
&& Salesline.createdDate <= ToDate
&& Salesline.Dimension[dims] == dim[dims]
Does Anyone perhaps know where im going wrong;
I have tried switching them around Ant help would be Appreciated Thanks Jason
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://us.ard.yahoo.com/SIG=129c4dbth/M=298184.5285298.6392945.3001176/D=groups/S=1705006764:HM/EXP=1092395510/A=2164331/R=0/SIG=11eaelai9/*http:/www.netflix.com/Default?mqso=60183351>
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2164331/rand=794835688>
________________________________
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]>
* 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.
