SQL Scripts for Microsoft Dynamics GP: Update Inactive Flag on Items from CSV

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

Read original post SQL Scripts for Microsoft Dynamics GP: Update Inactive Flag on Items from CSV at azurecurve|Ramblings of an IT Professional