Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Routines Routines Documentation

Search
Create new routine Create new routine
There are no routines to display.
Name Type Returns
DROP PROCEDURE IF EXISTS `ExportInventoryData` ExportInventoryData PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetClientProductPercentage` GetClientProductPercentage PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetClientProductPercentage_ByBranch` GetClientProductPercentage_ByBranch PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetInventoryByBranch` GetInventoryByBranch PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetInventoryByMonthYear` GetInventoryByMonthYear PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetInventoryForMonth` GetInventoryForMonth PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetPreviousMonthEntriesForSalesman` GetPreviousMonthEntriesForSalesman PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanClientPercentageByBranch` GetSalesmanClientPercentageByBranch PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanPhotoReport` GetSalesmanPhotoReport PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanPhotoReport_AllMonth` GetSalesmanPhotoReport_AllMonth PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanPhotoReport_Filtered` GetSalesmanPhotoReport_Filtered PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanPhotoReport_Filtered_month` GetSalesmanPhotoReport_Filtered_month PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSalesmanPhotoSummaryAllBranches` GetSalesmanPhotoSummaryAllBranches PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `GetSpeceficSalesmanPercentage` GetSpeceficSalesmanPercentage PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `MovePreventedClientProductsBySalesman` MovePreventedClientProductsBySalesman PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `MovePreventedToClientProducts` MovePreventedToClientProducts PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `RefreshInventorySummary` RefreshInventorySummary PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `get_salesman_inventory_by_date_range` get_salesman_inventory_by_date_range PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `spGetClientNotesByDateRange` spGetClientNotesByDateRange PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `spGetTotalQuantityByProduct` spGetTotalQuantityByProduct PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `spGetTotalQuantityByProductByDate` spGetTotalQuantityByProductByDate PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_client_photo_monthly_status` sp_client_photo_monthly_status PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_client_photo_status_by_branch` sp_client_photo_status_by_branch PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_get_low_inventory` sp_get_low_inventory PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_get_salesmen` sp_get_salesmen PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_by_branch` sp_inventory_by_branch PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_report` sp_inventory_report PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_report_date_range` sp_inventory_report_date_range PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_report_two` sp_inventory_report_two PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_summary` sp_inventory_summary PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_inventory_trend` sp_inventory_trend PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_photo_rice` sp_photo_rice PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_salesman_photos_report` sp_salesman_photos_report PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_total_product_quantities_all_branches` sp_total_product_quantities_all_branches PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_total_product_quantities_pivot` sp_total_product_quantities_pivot PROCEDURE Edit Edit Execute Execute Export Export Drop Drop
DROP PROCEDURE IF EXISTS `sp_total_product_quantities_pivot_dynamic` sp_total_product_quantities_pivot_dynamic PROCEDURE Edit Edit Execute Execute Export Export Drop Drop