I guess next line in error message was like next:
Column name 'A.SALESID' is invalid in the ORDER BY clause because it
is not contained in either an aggregate function or the GROUP BY
clause.
SO,
while select sum(Field) from localSalesParmTable
order by Field desc ...
OR (may be)
while
Hello Hans,
Yesterday, i looked up the query generated by AX using the SQL trace and I
noticed that AX automatically puts the Order By clause on the query before
sending.
In the example below, running it at SQL Query Analyzer, once the order by is
embedded by AX query, I get sorted result
Hi Daniel
You need to look in the application event log on the machine running
the AOS - you will get more detail about what SQL Server is objecting
to.
Hans
--- In Axapta-Knowledge-Village@yahoogroups.com, Daniel Zanni
[EMAIL PROTECTED] wrote:
Hello,
I have a SQL statement like this
3 matches
Mail list logo