RE: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-27 Thread Pieter Wijnen
My guess is that order by sum... is the culprit try using the alias instead HTH Pieter -Original Message-From: Don Price [mailto:[EMAIL PROTECTED]Sent: 22. april 2004 17:50To: [EMAIL PROTECTED]Subject: RE: [development-axapta] Query with ORDER BY and GROUP BY One

RE: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-27 Thread Malcolm Burtt
: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement? In SQL92 it would look like this: SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount, ITEMID FROM CUSTINVOICETRANS WHERE (INVOICEDATE

[development-axapta] Query with ORDER BY and GROUP BY

2004-04-22 Thread Werner Briedl
Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement? In SQL92 it would look like this: SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount, ITEMID FROM CUSTINVOICETRANS WHERE (INVOICEDATE = CONVERT(DATETIME, '2004-01-07 00:00:00', 102)) GROUP BY ITEMID

Re: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-22 Thread Ing. Gonzalo Bastos S.
, ', ', custInvoiceTrans.Qty, ', ', custInvoiceTrans.LineAmount;}} - Original Message - From: Werner Briedl To: [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:01 AM Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can

AW: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-22 Thread Werner Briedl
by sum(LineAmount) desc{} regards, Werner. Von: Ing. Gonzalo Bastos S. [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 22. April 2004 15:41An: [EMAIL PROTECTED]Betreff: Re: [development-axapta] Query with ORDER BY and GROUP BY Hi Werner: The sintax of the first SQL Statement is good, a SQL

RE: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-22 Thread Don Price
(sqlTable.getInt(1)); //or whatever you need } Don -Original Message- From: Werner Briedl [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 22, 2004 4:02 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER

RE: [development-axapta] Query with ORDER BY and GROUP BY

2004-04-22 Thread Don Price
-Original Message- From: Werner Briedl [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 22, 2004 4:02 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Query with ORDER BY and GROUP BY Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement