Query:
SELECT * FROM
(
SELECT ROW_NUMBER () OVER (ORDER BY RecId) AS RowNum, * FROM SALESTABLE
) sub
WHERE RowNum = 9
Wednesday, March 15, 2023
Subscribe to:
Post Comments (Atom)
Search hierarchy for a match (TableALLGroup) X++
Table1 ppt; select firstonly ppt order ItemCode, ItemRelation, AccountCode, AccountRelation where (ppt.ItemCode == TableGroupAll::T...
-
Restore .bacpac file to Development VM Steps: 1. Take Backup of AxDB database from Development VM 2. Open Command Pr...
-
Posting Vendor invoice based on Product receipt public void postPurchaseInvoiceJournal() { VendPackingSlipJour vendP...
-
Code for reserve and unreserved sales order lines Inputs : SalesLine, InventDim (Combination to reserve), Qty Note : To Reserve -> Pass...
No comments:
Post a Comment