Finance & Operations
Refresh new objects in SQL server
Whenever we create a new object (table/View/Stored procedure etc) in SQL server , the change will not be immediately reflected in query window. Intelisense…
Tag: SQL
Dynamics 365 Customer Engagement
Export Dataverse data to SQL using Data Lake and ADF
I recently had the challenge of exporting Dataverse data to an SQL Database. I ended up using an Azure Data Lake Gen2 in combination…
Dynamics 365 Great Plains
SQL View to Get Assembly BOM Items for Sales Transactions in Microsoft Dynamics GP
=[/sqlgrey]“dynamicsgp”]This script was written for a client who uses Inventory BOMs in Microsoft Dynamics GP and wanted to be able to see all of…
Dynamics 365 Great Plains
Change Text in Stored Procedure on Microsoft SQL Server
I did some work for a client recently creating a script which they could run after copying their live Microsoft Dynamics GP system to…
Dynamics 365 Business Central
SQL – Search for special characters
Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to…