SQL – Page 27 – 365 Community Online

Dynamics 365 Business Central, Azure SQL and Optimized Locking

Optimized locking is a new Azure SQL database engine feature recently announced that drastically reduces lock memory and the number of locks concurrently required…

22 February 2023 · Stefano Demiliani

Dynamics 365 Great Plains

SQL Scripts for Microsoft Dynamics GP: Select Workflow Comments for Work Status Batches

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics…

6 January 2023 · Ian Grieve

Dynamics 365 Great Plains

SQL Scripts for Microsoft Dynamics GP: Remaining Budget By Year Using PO Commitment Budget

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics…

5 January 2023 · Ian Grieve

Dynamics 365 Great Plains

SQL Scripts for Microsoft Dynamics GP: Get Items Showing Quantities By Type

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics…

4 January 2023 · Ian Grieve

Dynamics 365 Great Plains

SQL Scripts for Microsoft Dynamics GP: Vendors With Emails From Primary, Remit and Purchase Addresses

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics…

3 January 2023 · Ian Grieve