Microsoft Dynamics Ax, Application Integration Framework, X++ programming, AX 2009 , 2012.Ax Rainier or version 7, Enterprise portal, SharePoint , BI Tools, OLAP, Performance Tuning, SSRS,SSIS,SSAS, Workflow.

Sunday, January 20, 2013

Ways to sort data on a select statement in axapta

Using existing indexes on the tables

The order by clause in a select statement that will return records in ascending order by default and if specified, can return them in descending order.

The group by clause in a select statement will group records by a selected field.