SQL Select Statement for COUNT in Ax

I am using the same table Bill_TabMethod for SQL Count.

Step 1. Write the below SQL Select statement in a Job like below


static void SQLCount(Args _args)


Bill_TabMethod btm;

while select count(CustName) from btm

print “Number of Records :  “,btm.CustName;



Step 2. Run the code you will get the Result as

Number of Records : 11

Yes you have done…