This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script update the inactive flag on items from a CSV allowing items to be set to inactive or back to active en masse.
/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
CREATE TABLE #UploadData
(ITEMNMBR VARCHAR(100)
,INACTIVE BIT)
GO
BULK INSERT
#UploadData
FROM
'c:\TEMP\Items.txt'
WITH
(FIELDTERMINATOR = ','
,ROWTERMINATOR = '\n'
,FIRSTROW = 2)
GO
UPDATE
['Item Master']
SET
INACTIVE = ['Upload Data'].INACTIVE
FROM
IV00101 AS ['Item Master'] --Item Master (IV00101)
INNER JOIN
#UploadData AS ['Upload Data']
ON
['Upload Data'].ITEMNMBR = ['Item Master'].ITEMNMBR
GO
DROP TABLE #UploadData
GO
