David Musgrave looks at Using SQL to return the number of records in a Table – Developing for Dynamics GP
Quick Tip: Using SQL to return the number of records in a Table – Developing for Dynamics GP
SQL & DataTips & Hidden Features
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.