I don’t recall when I wrote this SQL view, but I stumbled across it when I was looking for something else and thought it worth posting.
It uses a common table expression to return the most recent five purchase orders for each vendor.
-- drop view if it exists
IF OBJECT_ID(N'uv_AZRCRV_MostRecentFivePurchaseOrdersByVendor ', N'V') IS NOT NULL
DROP VIEW...
Continue Reading Ian Grieve’s Article on their blog
SQL View to return most recent five purchase orders by vendor
I don’t recall when I wrote this SQL view, but I stumbled across it when I was looking for something else and thought it worth posting. It uses a common table expression to return the most recent five purchase orders for each vendor.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 February 2024SQL Query on Matomo Database to Calculate the Number of Visits to Each Page
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Virtual Tables to Expose More Business Central Data in Dataverse
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Work Orders in Field Service, Invoice Them in Business Central
- Dyn365GP2 February 2024In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location