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
: [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
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
, ', ', 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
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
(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
-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
7 matches
Mail list logo