Data Migration

ALTER PROCEDURE [dbo].[UpdateProductFromNavision]

AS

Truncate Table [TempProduct_Master]

INSERT INTO [dbo].[TempProduct_Master]
(ProductGroupCode,Product_Name,ProductNo,UOM)
SELECT [ProductGroupCode],[Description],[No],[UnitOfMeasure]
FROM [dbo].[ItemMaster]