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