Anonymize-Isah-Data_4.7.2.sql

/*
Anonymize data in Isah databases
Based on Isah DB Version 4.7.3 (SELECT * FROM T_DBVersion)
Version 2019.05.23.00

Tambien 2019
This sql script may be used at your own risk. 
Tambien will not accept any responsibility for the functionality of this script.
Tambien hereby grants anyone the right to use and modify this script to it's own liking.
It is appreciated when improvements to the script are sent to anonymize@tambien.nl.

WARNING
Take note that the script modifies data in the database which can cause the database to stop functioning.
Test the script in a safe environment before using it in your production environment.

This script will take some time to complete, be patient!
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON
GO

IF DB_NAME() not like '%anonimized%'
BEGIN
	PRINT 'This script is targetted to run on database '+db_name()+ '. We expecteed the name to contain the word anonimized. The script is halted.'
END
ELSE
BEGIN
	PRINT 'Start logging'
	IF NOT EXISTS (SELECT
				*
			FROM sysobjects
			WHERE Name = 'ST_T_Anonymized'
			AND xtype = 'U')
		CREATE TABLE ST_T_Anonymized (
			id NUMERIC(18, 0) IDENTITY NOT NULL
		   ,IsahDBVersion NVARCHAR(20) NOT NULL
		   ,AnonymizeVersion NVARCHAR(20) NOT NULL
		   ,StartedAt DATETIME NOT NULL
		   ,CompletedAt DATETIME NULL
		)
	GO
	DECLARE @AnonymizeVersion NVARCHAR(13)
		   ,@AnonymizedId NUMERIC(18, 0)
		   ,@IsahDBVersion NVARCHAR(10)
	SELECT
		@AnonymizeVersion = '2019.05.23.00'
	SELECT
		@IsahDBVersion = (SELECT
				RTRIM(DBMajor) + '.' +
				RTRIM(DBMinor) + '.' +
				RTRIM(DBRelease) + '.' +
				RTRIM(DBBuildNr)
			FROM T_DBVersion)

	INSERT INTO ST_T_Anonymized (IsahDBVersion, AnonymizeVersion, StartedAt)
		VALUES (@IsahDBVersion, @AnonymizeVersion, GETDATE())
	SELECT
		@AnonymizedId = MAX(id)
	FROM ST_T_Anonymized

	PRINT 'Create Helper tables'
	--HelpIban
	CREATE TABLE #HelpIban (
		iban NVARCHAR(34)
	)
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0100541127')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0101033672')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0101173601')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0101184611')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0101237081')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0101804067')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0101859201')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0102291985')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL61TEST0102391211')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0103212140')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0103261230')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0103706526')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0103852174')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0104699841')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0104855711')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0105068950')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0105360538')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0105467502')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0105766623')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0105942847')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0106193090')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0106256033')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0106749838')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0106905961')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0107704633')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0107902443')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0108101320')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0108240495')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0109275314')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0109401514')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0109925955')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0110649508')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0111146224')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0111897904')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0112664687')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0113056435')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0113066937')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0113665024')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0114161259')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0114209626')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0114519331')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0114974918')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0115075453')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0115434224')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0115450785')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0115780483')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0116074604')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0116228709')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0116462760')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0116518340')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0116635878')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0116686057')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0117293768')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0117385549')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0117501751')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0117959642')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0118238353')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0118248685')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0118479016')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0119216566')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0119388243')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0120060116')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0120216213')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0120415089')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0121526550')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0122666593')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0122892119')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0123459648')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0124735436')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0124804217')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0125238975')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0125303270')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0125450613')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0125587457')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0125983654')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0126600910')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0126848211')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0126900418')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0127376062')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0127693459')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0128023171')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0128076461')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0128156287')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0128184442')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0128292369')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0128657154')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0128838027')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0129046272')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0129365769')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0129742902')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0129846996')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0130024090')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0130024198')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0130540854')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0131181688')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0131277685')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0131290134')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0131492195')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0131682342')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0131826271')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0132589001')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0133275744')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0133443027')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0133495884')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0133837963')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0134327144')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0134701976')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0135413036')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0136353479')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0136475639')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0136722350')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0137480636')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0137670788')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0138244103')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0138447594')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0138519617')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0138712999')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0139093834')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0139429417')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0139496831')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0139815767')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0140376259')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0140528814')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0140726578')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0141262508')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0141883065')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0142154997')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0142560375')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0142821756')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0142873039')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0143248693')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0143752553')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0143786695')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0144067323')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0144590883')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0144949016')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0145036316')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0145969436')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0146061403')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0146335457')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0146603346')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0147097045')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0147378729')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0147598621')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0147684455')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0147754577')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0147886139')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0148244157')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0148250424')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0148464300')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0148778364')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0149566670')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0149759509')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0149776624')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0150170238')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0150334656')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0150417217')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0151118876')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0151199302')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0151478430')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0151578508')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0152068929')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0152281940')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0153413808')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0153574771')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0153699140')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0153996773')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0154124281')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0155163744')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0155204343')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0155423096')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0155717634')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0156804549')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0157047326')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0157383482')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0157574164')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0158090306')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0158673549')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0158791320')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL59TEST0159220734')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0159461049')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0160264456')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0160281350')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0160366135')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0160783194')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0161327842')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0161329497')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0161334172')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0161349137')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0161849326')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0162908423')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0163536198')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0164551948')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0164613609')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0164769692')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0165110961')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL61TEST0165530839')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0166040908')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0166229709')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0166307505')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL88TEST0166579408')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0166755958')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0166992941')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0167023446')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0167254715')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0167594281')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0167648802')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0167738429')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0167944061')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0168018799')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0168330806')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL26TEST0168483858')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0168552094')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0168599295')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0168693569')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0168925842')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0169574431')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0169641066')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0169705242')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0170073254')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0170342239')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0170498972')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0170601498')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0170933873')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0171015940')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0171069226')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0171391136')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0171701585')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0172530563')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0172772788')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0172928478')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0173432093')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0174287119')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0174456220')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0174860390')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0177076917')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0177130482')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0177277092')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0177488972')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0177494506')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0177846348')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0177891688')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0178110167')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0178323691')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0178574147')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0178582808')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0178844020')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0179394762')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0179527177')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0179835017')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0179865196')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0180366157')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0180398075')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0180714147')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0180830325')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0180891642')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0182360121')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0182547132')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0182709604')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0183168666')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0183489349')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0183520076')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0183806476')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0184109736')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0184121639')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0184319145')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0184770890')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0184813603')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0184815282')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0184824923')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0184855403')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0184909406')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0185080057')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0185807275')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0185844537')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0186469861')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0186539347')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0187054258')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0187370613')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0187912440')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0188056297')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0188141731')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0188218726')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0189337842')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0189425075')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0189465271')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL41TEST0189688564')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0189739762')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0190237015')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0190269162')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0191374806')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0191598348')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0191866598')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0192114115')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0192227181')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0192445936')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0192470604')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0193001985')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0193247453')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0194157970')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0194490149')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0194563251')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0194682587')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0195609581')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0196318351')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0196479061')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL75TEST0196547016')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0196666066')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0196747198')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0196767326')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0197114318')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0197130755')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0197378625')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0197551068')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0197687164')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0197720250')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0198670125')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0198684959')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0198928726')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0199693250')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0199966710')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0200241567')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0200313649')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0200338927')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0200385321')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0200741233')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0201063255')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0201518074')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0201676087')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0202042529')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0202274012')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0202484475')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL75TEST0203719778')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0203981308')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0204009294')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0204070295')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0204240727')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0204528054')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0204580145')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0205260691')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0205756042')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0205976824')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0205976913')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0206143885')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0206294123')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0206324316')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0206567863')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0206873360')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0207024685')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0207486425')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0209418966')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0210077166')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0210156155')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0210156295')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0210652616')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0210754176')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0210842075')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0211321737')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0211347663')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0211425044')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0211432679')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0211485101')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0211590886')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0211674486')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0211938483')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0212764756')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0213582902')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0213653141')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0213754150')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0213880326')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0214120732')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0214228495')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0214375242')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL75TEST0214419169')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0214952118')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0214970558')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0215212185')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0215409698')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0215473957')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0215577361')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0215937724')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0216162394')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0216263832')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0216877865')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0217552404')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0217795285')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0218124465')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0218257279')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0218656203')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0218908210')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0219849773')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0220173974')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0220363528')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0220387419')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL88TEST0220500835')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0220770824')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0220772479')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0220812500')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0221170839')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0221240152')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0221351272')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0221470328')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0221591923')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0221942521')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0222147067')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0222529083')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0222780835')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0223083674')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0223463418')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0223635073')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0223877689')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0223955582')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0224522833')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0224673637')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0224879308')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0225380528')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0225396335')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0226377962')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0226893154')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0227116348')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0227141059')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0227727959')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0228729556')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0228870860')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0228991102')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0229400841')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0229775578')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0230650627')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0231148062')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0231423195')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0231681682')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0231700083')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0232073686')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0232156573')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0232286744')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0232556016')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0232637970')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0232704635')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0232868581')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0233515984')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0233787585')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0233789871')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0233801022')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0234027126')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0234049189')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0234077808')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0234450207')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0235079073')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0235098027')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0235277568')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0235567833')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0236578898')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0236607294')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0237163411')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0237221209')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0237885956')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0238094464')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0238505820')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0238940543')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL25TEST0239873645')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0239985036')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0240034686')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0240229002')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0240469216')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0240978005')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0241401348')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0242033709')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0242286763')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0242617379')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0243008058')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0243084951')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0243538286')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0243764162')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0244009252')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0244768080')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0244966133')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0245100555')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0245197702')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0245718354')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0247026123')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0247287237')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0247500356')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0247791245')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0249254093')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0249404222')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0249985721')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0250621126')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0250815613')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0251553477')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0252385314')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0252525892')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0252966228')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0253478499')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0253660947')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0253851203')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0254735266')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0254738516')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0255205279')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0255265859')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0255355432')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0255468806')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0255603959')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0256008124')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0256249083')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0256345023')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0256425388')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0256557349')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0257411526')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0257777504')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0258481129')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0258579714')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0259583634')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0259738441')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0259783021')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0260184071')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0260638889')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0261007491')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0261717405')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0262135698')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0262137127')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0262181088')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL61TEST0263369404')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0263411796')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0263663892')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0263826813')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0263878686')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0263918939')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0263963012')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL88TEST0264141717')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0264240286')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0264298837')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0264727762')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0265442672')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0265610737')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0265913896')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0266015395')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0266384927')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0266945201')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0266949398')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0267579764')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0267726279')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL41TEST0267740875')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0267849508')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0268076057')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL25TEST0268394458')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0268518173')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL59TEST0269068481')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0269214232')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0269536108')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0269754806')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0269848169')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0271168633')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0271232250')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0271645903')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0272097217')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL61TEST0272696730')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0272711810')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0272897019')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0273312596')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0273379186')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0273495291')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0273682318')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0273743619')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0273987941')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0273997750')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0274230828')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0274325640')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0274507757')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0274699133')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0274842874')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0275501787')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0275809919')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0276433572')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0276674502')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0276750128')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0276796993')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0276803094')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0277261015')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0277735033')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0278356397')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0278364128')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0278390951')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0278671535')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0278775012')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0279146833')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL25TEST0279445474')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0279949731')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0279975813')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0280117531')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0280909462')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0280932758')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0281083681')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0281287511')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0281417156')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0281627711')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0281862338')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0282949461')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0283414774')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0284510793')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0284572780')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0284933694')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0285538020')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0285543873')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0286298686')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0286516349')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL25TEST0286678764')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0286931443')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0287300102')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0287422186')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0288162587')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0288293835')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL41TEST0288594711')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0288780906')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0289090482')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0289456991')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL59TEST0289863341')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0290145430')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0290771463')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL88TEST0290992966')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0291104568')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0291374816')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0291690572')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0292635648')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0292724381')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0292765894')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0293089981')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0293101345')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0293374988')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0293537526')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0293787778')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0294342273')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0294599002')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0294649824')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0294925198')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0294973869')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0295685492')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0295934506')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0296316954')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0296642886')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0296762547')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0296842893')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0296862320')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0296999334')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0297366858')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0298295938')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0298712709')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0298779021')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0298806711')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0299422763')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0299515524')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0299797570')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0300897545')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0300942370')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0301235872')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0301264708')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0301330794')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0301336970')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0301640580')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0301641498')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0301723249')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0301724326')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0302461558')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0302746455')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0303125357')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0303808683')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0304060844')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0304076511')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0304217670')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0304797251')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0304970166')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0305185497')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0305376691')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0305446061')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0306031981')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0306394006')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0306630702')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0306818965')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0307242099')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0307363384')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0307452042')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0308290801')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0308479742')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0308763742')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0308822765')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0309056071')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0309129877')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0309636132')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0309643953')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0309810795')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0309960371')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0310062357')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0310433495')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0310954460')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0311049680')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0311181309')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0311203396')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0312546807')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL88TEST0312625421')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0312937008')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0313262861')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0313361754')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0313658242')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0313795754')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0313971943')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0314035338')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0314791612')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0314829229')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0314916385')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0315051817')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0315191104')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0316006467')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0316749206')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0316977969')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0317065785')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0317545000')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0318013231')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0318291509')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL26TEST0319154637')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0319306194')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0319453294')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0319645975')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0319777731')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0320372588')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0320389154')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0320432459')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0320914186')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0321214153')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0321234049')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0321241436')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0321370392')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0321862082')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0322475163')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0322828465')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0322834643')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0323648029')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0323650155')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0323871518')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0324142749')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0324254709')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0324489382')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0325379947')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0325910642')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL41TEST0325960275')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL17TEST0326590528')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0326799761')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0327123486')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0327201754')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0327206659')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL04TEST0327221941')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0327906618')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0328123579')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0328239054')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0328710229')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0329129716')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0329593072')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0330086871')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0330376888')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0330953699')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0331717409')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0331876833')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0332174816')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0332255247')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0332305767')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL74TEST0332539482')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0332831566')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL10TEST0333024567')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0333081455')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0333277414')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0333364090')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0333467140')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0333681916')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL66TEST0333766288')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0333822838')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0334177197')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0334186692')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0334330491')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0334359422')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0334518377')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0334727383')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0334893240')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0335069576')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0335090915')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0335187943')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0335239412')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL95TEST0335314759')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL93TEST0336185855')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0336187947')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0336236271')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0336930356')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0337466300')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0337558809')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL58TEST0337782717')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0338016937')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0338093338')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0338143823')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0338494235')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0338674403')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0339711027')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0339736402')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0340010223')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL71TEST0340586656')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0340706104')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0340739894')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0340815736')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0340976985')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL76TEST0341191264')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0341631493')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0342397818')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0342466593')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0342726781')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0342858408')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL08TEST0342974378')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0343021420')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL75TEST0343022060')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0343859122')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0344012506')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0344017885')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0345387139')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL89TEST0345786017')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0345824423')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0345917677')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0346139848')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0346185793')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0346547547')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0346630886')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0346804914')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0346872790')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL28TEST0347057330')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0347278205')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0347660525')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0347661769')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0348194609')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0348316089')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL48TEST0348388489')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0348448317')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0348588429')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0348634137')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0348634765')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL20TEST0348813562')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0348999305')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0349005036')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL59TEST0349330646')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0350148430')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0350273278')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0350494479')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0350589461')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL39TEST0350628963')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0351491309')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL38TEST0351564837')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL57TEST0351926984')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0352008512')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0352210753')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL15TEST0352276940')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0352614560')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0352795387')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0353334340')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0354301357')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0356203492')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0356213315')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0356649385')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0357039319')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0357076680')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0357558006')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL55TEST0357760697')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL33TEST0357844513')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0357857089')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0358293669')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL72TEST0359451004')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL42TEST0359468713')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0360086241')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL41TEST0360103499')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0360363628')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL56TEST0361384114')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0361706731')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0362019339')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL47TEST0362998744')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL09TEST0363033572')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL40TEST0363255532')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0363718885')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0363799788')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0364275510')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL32TEST0364287756')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL14TEST0364570156')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0364652039')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL61TEST0365040924')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0365117927')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0365449725')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0365498408')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0365839493')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0366875043')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL25TEST0367064022')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0367221721')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL07TEST0367342057')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL92TEST0367822423')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0368058530')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL13TEST0368669297')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL83TEST0368783855')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL52TEST0368869385')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0369829964')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL60TEST0370345096')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL34TEST0371322839')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0371887828')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL96TEST0372070175')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0372240968')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0372310168')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL18TEST0372395074')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0372561705')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL82TEST0372627110')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0372660320')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0372716415')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0372803962')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0373212453')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0373554656')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0373811802')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL26TEST0374276536')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL78TEST0374599580')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0374633665')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0374642397')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0374982716')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0375252037')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0375402497')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL45TEST0375412646')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0375444300')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0376291044')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0376459549')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL23TEST0376672005')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0376940581')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0377902810')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0378124900')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL59TEST0378668005')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL54TEST0378845993')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL43TEST0379376490')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL94TEST0379565110')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0380313464')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0380841428')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL46TEST0380850060')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL49TEST0381231313')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0381269116')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0381401758')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL53TEST0381641260')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0381852164')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0381965090')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0382353528')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL12TEST0382557387')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0382673913')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0382702425')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL98TEST0382791452')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL77TEST0382951395')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0382954327')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL51TEST0383336759')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0383704553')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL06TEST0383722659')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0383811449')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0384080111')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL50TEST0384266231')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL37TEST0384821111')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL87TEST0384845916')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL35TEST0385149492')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL24TEST0385875444')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL26TEST0386495335')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0386731330')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL31TEST0387684271')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL29TEST0387856676')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL84TEST0388485604')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL19TEST0388585811')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL85TEST0389275069')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0389646091')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL67TEST0390358398')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL70TEST0390479012')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL03TEST0390914584')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL44TEST0391113763')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL81TEST0391594605')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0391718185')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0392836726')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0393002373')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL79TEST0393055558')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL80TEST0393436071')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL65TEST0393459233')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL30TEST0393529606')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL91TEST0393996824')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL63TEST0394925327')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL97TEST0394954300')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL27TEST0395502640')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0395590833')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL69TEST0396206298')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL16TEST0396352170')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL64TEST0396757057')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL62TEST0396808018')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL05TEST0397680686')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL36TEST0397882955')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL68TEST0397884125')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL22TEST0397900279')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL11TEST0398104468')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL73TEST0398116350')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL86TEST0398116601')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL90TEST0398140197')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL26TEST0398153183')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL02TEST0398302219')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0398607524')
	INSERT INTO #HelpIban (iban)
		VALUES ('NL21TEST0398909873')

	--#HelpVAT
	CREATE TABLE #HelpVAT (
		VAT NCHAR(15)
	)
	INSERT INTO #HelpVAT (VAT)
		VALUES ('ATU00000024')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('BE0100200307')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('BG0000100153')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('CHE100416306IVA')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('NO864234232')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('RS100010812')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('RU0274051582')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('RU2901081545')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('CY00001067Y')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('CZ00008702')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('DE111111125')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('DK10000009')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('EE100007796')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('EL000000024')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('ES00000001R')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('EU826001142')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('FI00000027')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('FR00000000190')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('GB999000047')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('HR02574432339')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('HU10672101')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('IE1113011UH')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('IT00000010215')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('LT100000009017')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('LU25318872')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('LV07091910933')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('MT10126313')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('NL000000024B01')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('PL1132191233')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('PT100000010')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('RO10310742')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('SE000000002601')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('SI10693661')
	INSERT INTO #HelpVAT (VAT)
		VALUES ('SK1025529197')

	PRINT 'Processing T_BankAccount'
	DECLARE @BankAccountID INT
		   ,@RndIban NVARCHAR(34)

	DECLARE cursBankAccount CURSOR FOR SELECT
		BankAccountId
	FROM T_BankAccount
	OPEN cursBankAccount;
	FETCH NEXT FROM cursBankAccount INTO @BankAccountID

	WHILE @@fetch_status = 0
	BEGIN
	SELECT
		@RndIban = (SELECT TOP 1
				iban
			FROM #HelpIban ti
			ORDER BY NEWID())
	UPDATE T_BankAccount
	SET iban = @RndIban
	   ,BankAccount = ''
	WHERE BankAccountId = @BankAccountID
	SELECT
		@RndIban = NULL
	FETCH NEXT FROM cursBankAccount INTO @BankAccountID
	END

	CLOSE cursBankAccount;
	DEALLOCATE cursBankAccount;

	PRINT 'Processing T_BankAccountLog'
	TRUNCATE TABLE T_BankAccountLog

	PRINT 'Processing T_CallRegistration'
	UPDATE T_CallRegistration
	SET Description = 'Description ' + RTRIM(CONVERT(CHAR, CallNr))
	   ,Info = 'Info ' + RTRIM(CONVERT(CHAR, CallNr))

	PRINT 'Processing T_Customer'
	UPDATE T_Customer
	SET Mnem = RTRIM(CONVERT(CHAR, CustId))
	WHERE Mnem IS NOT NULL
	UPDATE T_Customer
	SET Info = 'Info ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE Info IS NOT NULL

	PRINT 'Processing T_CustomerLog'
	TRUNCATE TABLE T_CustomerLog

	PRINT 'Processing T_CustomerAddress'
	UPDATE T_CustomerAddress
	SET Name = 'Customer ' + RTRIM(CONVERT(CHAR, CustId))
	UPDATE T_CustomerAddress
	SET NameExt = 'NameExt ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE NameExt IS NOT NULL
	AND RTRIM(NameExt) <> ''
	UPDATE T_CustomerAddress
	SET Addr = 'Address ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE Addr IS NOT NULL
	AND RTRIM(Addr) <> ''
	UPDATE T_CustomerAddress
	SET Addr2 = 'Address2 ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE Addr2 IS NOT NULL
	AND RTRIM(Addr2) <> ''
	UPDATE T_CustomerAddress
	SET Addr3 = 'Address3 ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE Addr3 IS NOT NULL
	AND RTRIM(Addr3) <> ''
	UPDATE T_CustomerAddress
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEFT(RIGHT(PostCode, 3), 1) = ' '
	UPDATE T_CustomerAddress
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEN(PostCode) = 6
	AND ISNUMERIC(LEFT(PostCode, 4)) = 1
	AND ISNUMERIC(RIGHT(PostCode, 2)) <> 1
	UPDATE T_CustomerAddress
	SET State = 'State ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE State IS NOT NULL
	AND RTRIM(State) <> ''
	UPDATE T_CustomerAddress
	SET Phone = '+31 13 7113195'
	WHERE Phone IS NOT NULL
	AND RTRIM(Phone) <> ''
	UPDATE T_CustomerAddress
	SET Fax = '+31 13 7113195'
	WHERE Fax IS NOT NULL
	AND RTRIM(Fax) <> ''
	UPDATE T_CustomerAddress
	SET Telex = '+31 13 7113195'
	WHERE Telex IS NOT NULL
	AND RTRIM(Telex) <> ''
	UPDATE T_CustomerAddress
	SET Email = 'info@' + LOWER(RTRIM(CONVERT(CHAR, CustId))) + '.com'
	WHERE Email IS NOT NULL
	AND RTRIM(Email) <> ''
	UPDATE T_CustomerAddress
	SET WebSiteAddr = 'www.' + LOWER(RTRIM(CONVERT(CHAR, CustId))) + '.com'
	WHERE WebSiteAddr IS NOT NULL
	AND RTRIM(WebSiteAddr) <> ''
	UPDATE T_CustomerAddress
	SET Longitude = '5.063520'
	WHERE Longitude IS NOT NULL
	UPDATE T_CustomerAddress
	SET Latitude = '51.580000'
	WHERE Latitude IS NOT NULL
	UPDATE T_CustomerAddress
	SET VATNr = (SELECT
		TOP 1
			VAT
		FROM #HelpVAT hv
		WHERE LEFT(VAT, 2) = (SELECT
			TOP 1
				LEFT(VATNr, 2)
			FROM T_CustomerAddress
			WHERE VATNr IS NOT NULL
			AND RTRIM(VATNr) <> ''))
	WHERE VATNr IS NOT NULL
	AND RTRIM(VATNr) <> ''

	PRINT 'Processing T_CustomerAddressLog'
	TRUNCATE TABLE T_CustomerAddressLog

	PRINT 'Processing T_CustomerRelation'
	UPDATE T_CustomerRelation
	SET Name = 'Relation ' + RTRIM(CONVERT(CHAR, CustId)) + '-' + RTRIM(CONVERT(CHAR, CustRelCode))
	WHERE Name IS NOT NULL
	AND RTRIM(Name) <> ''
	UPDATE T_CustomerRelation
	SET Degree = 'Dr. '
	WHERE Degree IS NOT NULL
	AND RTRIM(Degree) <> ''
	UPDATE T_CustomerRelation
	SET FirstName = 'Firstname ' + RTRIM(CONVERT(CHAR, CustId)) + '-' + RTRIM(CONVERT(CHAR, CustRelCode))
	WHERE FirstName IS NOT NULL
	AND RTRIM(FirstName) <> ''
	UPDATE T_CustomerRelation
	SET Initials = 'I.N.I.'
	WHERE Initials IS NOT NULL
	AND RTRIM(Initials) <> ''
	UPDATE T_CustomerRelation
	SET JobDescription = 'Job ' + RTRIM(CONVERT(CHAR, CustId)) + '-' + RTRIM(CONVERT(CHAR, CustRelCode))
	WHERE JobDescription IS NOT NULL
	AND RTRIM(JobDescription) <> ''
	UPDATE T_CustomerRelation
	SET Dept = 'Dept ' + RTRIM(CONVERT(CHAR, CustId)) + '-' + RTRIM(CONVERT(CHAR, CustRelCode))
	WHERE Dept IS NOT NULL
	AND RTRIM(Dept) <> ''
	UPDATE T_CustomerRelation
	SET OfficePhone = '+31 13 7113195'
	WHERE OfficePhone IS NOT NULL
	AND RTRIM(OfficePhone) <> ''
	UPDATE T_CustomerRelation
	SET OfficeFax = '+31 13 7113195'
	WHERE OfficeFax IS NOT NULL
	AND RTRIM(OfficeFax) <> ''
	UPDATE T_CustomerRelation
	SET MobilePhone = '+31 13 7113195'
	WHERE MobilePhone IS NOT NULL
	AND RTRIM(MobilePhone) <> ''
	UPDATE T_CustomerRelation
	SET Email = 'relation@' + LOWER(RTRIM(CONVERT(CHAR, CustId))) + '-' + LOWER(RTRIM(CONVERT(CHAR, CustRelCode))) + '.com'
	WHERE Email IS NOT NULL
	AND RTRIM(Email) <> ''
	UPDATE T_CustomerRelation
	SET Selection = 'Selection ' + RTRIM(CONVERT(CHAR, CustId)) + '-' + RTRIM(CONVERT(CHAR, CustRelCode))
	WHERE Selection IS NOT NULL
	AND RTRIM(Selection) <> ''
	UPDATE T_CustomerRelation
	SET PrivAddr = 'Address ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE PrivAddr IS NOT NULL
	AND RTRIM(PrivAddr) <> ''
	UPDATE T_CustomerRelation
	SET PrivAddr2 = 'Address2 ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE PrivAddr2 IS NOT NULL
	AND RTRIM(PrivAddr2) <> ''
	UPDATE T_CustomerRelation
	SET PrivAddr3 = 'Address3 ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE PrivAddr3 IS NOT NULL
	AND RTRIM(PrivAddr3) <> ''
	UPDATE T_CustomerRelation
	SET PrivPostCode = LEFT(PrivPostCode, 4) + ' AA'
	WHERE PrivPostCode IS NOT NULL
	AND RTRIM(PrivPostCode) <> ''
	AND LEFT(RIGHT(PrivPostCode, 3), 1) = ' '
	UPDATE T_CustomerRelation
	SET PrivPostCode = LEFT(PrivPostCode, 4) + ' AA'
	WHERE PrivPostCode IS NOT NULL
	AND RTRIM(PrivPostCode) <> ''
	AND LEN(PrivPostCode) = 6
	AND ISNUMERIC(LEFT(PrivPostCode, 4)) = 1
	AND ISNUMERIC(RIGHT(PrivPostCode, 2)) <> 1
	UPDATE T_CustomerRelation
	SET PrivState = 'State ' + RTRIM(CONVERT(CHAR, CustId))
	WHERE PrivState IS NOT NULL
	AND RTRIM(PrivState) <> ''
	UPDATE T_CustomerRelation
	SET PrivPhone = '+31 13 7113195'
	WHERE PrivPhone IS NOT NULL
	AND RTRIM(PrivPhone) <> ''

	PRINT 'Processing T_Department'
	UPDATE T_Department
	SET Description = 'Dept ' + DeptCode
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''

	PRINT 'Processing T_DossierDetail'
	UPDATE T_DossierDetail
	SET Description = 'Salesline ' + RTRIM(DossierCode) + '-' + RTRIM(DetailCode) + '-' + RTRIM(DetailSubCode)
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''

	PRINT 'Processing T_DossierMain'
	UPDATE T_DossierMain
	SET Description = 'SalesOrder ' + RTRIM(DossierCode)
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''
	UPDATE T_DossierMain
	SET QuotRef = 'QuotRef ' + RTRIM(DossierCode)
	WHERE QuotRef IS NOT NULL
	AND RTRIM(QuotRef) <> ''
	UPDATE T_DossierMain
	SET OrdRef = 'OrdRef ' + RTRIM(DossierCode)
	WHERE OrdRef IS NOT NULL
	AND RTRIM(OrdRef) <> ''
	UPDATE T_DossierMain
	SET Info = 'Info ' + RTRIM(DossierCode)
	WHERE Info IS NOT NULL
	AND RTRIM(Info) <> ''

	PRINT 'Processing T_Employee'
	UPDATE T_Employee
	SET Name = 'Name ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE Name IS NOT NULL
	AND RTRIM(Name) <> ''
	UPDATE T_Employee
	SET ShortName = 'ShortName ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE ShortName IS NOT NULL
	AND RTRIM(ShortName) <> ''
	UPDATE T_Employee
	SET Degree = 'Dr. '
	WHERE Degree IS NOT NULL
	AND RTRIM(Degree) <> ''
	UPDATE T_Employee
	SET FirstName = 'Firstname ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE FirstName IS NOT NULL
	AND RTRIM(FirstName) <> ''
	UPDATE T_Employee
	SET Initials = 'I.N.I.'
	WHERE Initials IS NOT NULL
	AND RTRIM(Initials) <> ''
	UPDATE T_Employee
	SET JobDescription = 'Job ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE JobDescription IS NOT NULL
	AND RTRIM(JobDescription) <> ''
	UPDATE T_Employee
	SET OfficePhone = '+31 13 7113195'
	WHERE OfficePhone IS NOT NULL
	AND RTRIM(OfficePhone) <> ''
	UPDATE T_Employee
	SET MobilePhone = '+31 13 7113195'
	WHERE MobilePhone IS NOT NULL
	AND RTRIM(MobilePhone) <> ''
	UPDATE T_Employee
	SET Email = 'relation@' + LOWER(RTRIM(CONVERT(CHAR, EmpId))) + '.com'
	WHERE Email IS NOT NULL
	AND RTRIM(Email) <> ''
	UPDATE T_Employee
	SET Addr = 'Address ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE Addr IS NOT NULL
	AND RTRIM(Addr) <> ''
	UPDATE T_Employee
	SET Addr2 = 'Address2 ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE Addr2 IS NOT NULL
	AND RTRIM(Addr2) <> ''
	UPDATE T_Employee
	SET Addr3 = 'Address3 ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE Addr3 IS NOT NULL
	AND RTRIM(Addr3) <> ''
	UPDATE T_Employee
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEFT(RIGHT(PostCode, 3), 1) = ' '
	UPDATE T_Employee
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEN(PostCode) = 6
	AND ISNUMERIC(LEFT(PostCode, 4)) = 1
	AND ISNUMERIC(RIGHT(PostCode, 2)) <> 1
	UPDATE T_Employee
	SET State = 'State ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE State IS NOT NULL
	AND RTRIM(State) <> ''
	UPDATE T_Employee
	SET PrivPhone = '+31 13 7113195'
	WHERE PrivPhone IS NOT NULL
	AND RTRIM(PrivPhone) <> ''
	UPDATE T_Employee
	SET SoFiNr = '628101120'
	WHERE SoFiNr IS NOT NULL
	AND RTRIM(SoFiNr) <> ''
	UPDATE T_Employee
	SET DOB = DATEADD(DAY, (ABS(CHECKSUM(NEWID())) % 65530), 0)
	WHERE DOB IS NOT NULL
	AND RTRIM(DOB) <> ''
	UPDATE T_Employee
	SET Mnem = RTRIM(CONVERT(NCHAR(6), EmpId))
	WHERE Mnem IS NOT NULL
	UPDATE T_Employee
	SET Info = 'Info ' + RTRIM(CONVERT(CHAR, EmpId))
	WHERE Info IS NOT NULL

	PRINT 'Processing history tables'
	TRUNCATE TABLE T_HistPDPartRecptSchemeDateLog
	TRUNCATE TABLE T_HistPDPLineCostCenterLink
	TRUNCATE TABLE T_HistProcessedHour
	TRUNCATE TABLE T_HistProcessedHourLines
	TRUNCATE TABLE T_HistProdBillOfExtOper
	TRUNCATE TABLE T_HistProdBillOfMat
	TRUNCATE TABLE T_HistProdBillOfOper
	TRUNCATE TABLE T_HistProdBillOfSurcharge
	TRUNCATE TABLE T_HistProdBillOfTool
	TRUNCATE TABLE T_HistProdBOMDeliveryLine
	TRUNCATE TABLE T_HistProdBOMDesign
	TRUNCATE TABLE T_HistProdBomInvtLink
	TRUNCATE TABLE T_HistProdBOMShippingDetail
	TRUNCATE TABLE T_HistProdBOOGrp
	TRUNCATE TABLE T_HistProdHeadDosDetLink
	TRUNCATE TABLE T_HistProdHeadInvtLink
	TRUNCATE TABLE T_HistProdHeadProdBomLink
	TRUNCATE TABLE T_HistProdRoutingDetail
	TRUNCATE TABLE T_HistProdStatusLog
	TRUNCATE TABLE T_HistProductionHeader
	TRUNCATE TABLE T_HistProductionRouting
	TRUNCATE TABLE T_HistProductionScheme
	TRUNCATE TABLE T_HistPurchaseDocument
	TRUNCATE TABLE T_HistPurchasePartStatusLog
	TRUNCATE TABLE T_HistPurDocExtOperLine
	TRUNCATE TABLE T_HistPurDocExtOperLineDateLog
	TRUNCATE TABLE T_HistPurDocPartLine
	TRUNCATE TABLE T_HistPurDocPartReceiptScheme
	TRUNCATE TABLE T_HistPurDocToolLine
	TRUNCATE TABLE T_HistPurDocToolLineDateLog
	TRUNCATE TABLE T_HistPurInvDetailExtOper
	TRUNCATE TABLE T_HistPurInvDetailPart
	TRUNCATE TABLE T_HistPurInvDetailTool
	TRUNCATE TABLE T_HistPurInvoiceMain
	TRUNCATE TABLE T_HistPurInvoiceVat
	TRUNCATE TABLE T_HistPurRoutingDetail
	TRUNCATE TABLE T_HistSetting
	TRUNCATE TABLE T_HistShipEODProdBOM
	TRUNCATE TABLE T_HistShipEODProdBOT
	TRUNCATE TABLE T_HistShipEODProdRouting
	TRUNCATE TABLE T_HistShippingDetail
	TRUNCATE TABLE T_HistShippingDetailLocation
	TRUNCATE TABLE T_HistShippingExtOperDetail
	TRUNCATE TABLE T_HistShippingExtOperMain
	TRUNCATE TABLE T_HistShippingMain
	TRUNCATE TABLE T_HistShopDoc
	TRUNCATE TABLE T_HistToolDispatch
	TRUNCATE TABLE T_HistToShipExtOper
	TRUNCATE TABLE T_HistToShipExtOperProdBOM
	TRUNCATE TABLE T_HistToShipExtOperProdBOT
	TRUNCATE TABLE T_HistToShipExtOperProdRouting
	TRUNCATE TABLE T_HistCostProductionHeader
	TRUNCATE TABLE T_HistDailySchedule
	TRUNCATE TABLE T_HistDeliveryLine
	TRUNCATE TABLE T_HistDeliveryMain
	TRUNCATE TABLE T_HistDosDetConfiguration
	TRUNCATE TABLE T_HistDosDetInvtLink
	TRUNCATE TABLE T_HistDosMainConfiguration
	TRUNCATE TABLE T_HistDosMarkDeliveryMain
	TRUNCATE TABLE T_HistDosRoutingDetail
	TRUNCATE TABLE T_HistDossierDetail
	TRUNCATE TABLE T_HistDossierDocument
	TRUNCATE TABLE T_HistDossierMain
	TRUNCATE TABLE T_HistDossierMark
	TRUNCATE TABLE T_HistDossierMarkDetail
	TRUNCATE TABLE T_HistDossierStatusLog
	TRUNCATE TABLE T_HistFinJournal
	TRUNCATE TABLE T_HistFinJournalDetail
	TRUNCATE TABLE T_HistInstalmentInvoice
	TRUNCATE TABLE T_HistInvoiceDetail
	TRUNCATE TABLE T_HistInvoiceDetailDosDet
	TRUNCATE TABLE T_HistInvoiceMain
	TRUNCATE TABLE T_HistInvoiceVat
	TRUNCATE TABLE T_HistLogCustPartReceiptPBOM
	TRUNCATE TABLE T_HistLogDosDetSIPPreCalc
	TRUNCATE TABLE T_HistLogHourProdBOO
	TRUNCATE TABLE T_HistLogHourProdBOT
	TRUNCATE TABLE T_HistLogInvoicePDEOLine
	TRUNCATE TABLE T_HistLogInvoicePDPartLine
	TRUNCATE TABLE T_HistLogInvoicePDToolLine
	TRUNCATE TABLE T_HistLogInvtPartDispPBOM
	TRUNCATE TABLE T_HistLogMemoProdBOM
	TRUNCATE TABLE T_HistLogOrdPartDispPBOM
	TRUNCATE TABLE T_HistLogProdReceiptPHeader
	TRUNCATE TABLE T_HistLogPurInvoiceDosDet
	TRUNCATE TABLE T_HistLogPurInvoicePart
	TRUNCATE TABLE T_HistLogPurInvoiceProdBOE
	TRUNCATE TABLE T_HistLogPurInvoiceProdBOM
	TRUNCATE TABLE T_HistLogPurInvoiceProdBOT
	TRUNCATE TABLE T_HistLogPurReceiptDosDet
	TRUNCATE TABLE T_HistLogPurReceiptProdBOE
	TRUNCATE TABLE T_HistLogPurReceiptProdBOM
	TRUNCATE TABLE T_HistLogPurReceiptProdBOT
	TRUNCATE TABLE T_HistLogRealisedCostDosDet
	TRUNCATE TABLE T_HistLogRealisedCostPHeader
	TRUNCATE TABLE T_HistLogReceiptPDEOLine
	TRUNCATE TABLE T_HistLogReceiptPDPartLine
	TRUNCATE TABLE T_HistLogReceiptPDToolLine
	TRUNCATE TABLE T_HistLogShippingDossierDetail
	TRUNCATE TABLE T_HistMemorandumBook
	TRUNCATE TABLE T_HistPartConfiguration
	TRUNCATE TABLE T_HistPCSLogHourProdBOOLink
	TRUNCATE TABLE T_HistPCSLogHourProdBOTLink
	TRUNCATE TABLE T_HistPCSLogInvtPDPBOMLink
	TRUNCATE TABLE T_HistPCSLogMemoProdBOMLink
	TRUNCATE TABLE T_HistPCSLogPRPHLink
	TRUNCATE TABLE T_HistPCSLogPurInvoiceDDLink
	TRUNCATE TABLE T_HistPCSLogPurInvPBOELink
	TRUNCATE TABLE T_HistPCSLogPurInvPBOMLink
	TRUNCATE TABLE T_HistPCSLogPurInvPBOTLink
	TRUNCATE TABLE T_HistPCSLogPurRecptDDLink
	TRUNCATE TABLE T_HistPCSLogPurRecptPBOELink
	TRUNCATE TABLE T_HistPCSLogPurRecptPBOMLink
	TRUNCATE TABLE T_HistPCSLogPurRecptPBOTLink
	TRUNCATE TABLE T_HistPCSLogShippingDDLink
	TRUNCATE TABLE T_HistPDPartLineDosDetLink
	TRUNCATE TABLE T_HistPDPartLineProdBOMLink
	TRUNCATE TABLE T_HistPDPartLineVendQuot
	TRUNCATE TABLE T_HistPDPartLineWLocationLink

	PRINT 'Processing T_InvoiceDetail'
	UPDATE T_InvoiceDetail
	SET Description = 'Description ' + RTRIM(InvCode) + '-' + RTRIM(InvLineNr)
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''
	UPDATE T_InvoiceDetail
	SET Info = 'Info ' + RTRIM(InvCode) + '-' + RTRIM(InvLineNr)
	WHERE Info IS NOT NULL
	AND RTRIM(Info) <> ''

	PRINT 'Processing T_InvoiceMain'
	UPDATE T_InvoiceMain
	SET Info = 'Info ' + RTRIM(InvCode)
	WHERE Info IS NOT NULL
	AND RTRIM(Info) <> ''

	PRINT 'Processing T_MemoDetail'
	UPDATE T_MemoDetail
	SET Info = 'Info ' + RTRIM(MemoGrpId)
	WHERE Info IS NOT NULL
	AND RTRIM(Info) <> ''

	PRINT 'Processing T_Part'
	UPDATE T_Part
	SET Description = 'Description ' + RTRIM(PartCode)
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''
	UPDATE T_Part
	SET Remark = CONVERT(NCHAR(20), 'Remark ' + RTRIM(PartCode))
	WHERE Remark IS NOT NULL
	AND RTRIM(Remark) <> ''

	PRINT 'Processing T_ProductionHeader'
	UPDATE T_ProductionHeader
	SET Description = 'Description ' + RTRIM(ProdHeaderDossierCode)
	WHERE Description IS NOT NULL
	AND RTRIM(Description) <> ''
	UPDATE T_ProductionHeader
	SET Info = 'Info ' + RTRIM(ProdHeaderDossierCode)
	WHERE Info IS NOT NULL
	AND RTRIM(Info) <> ''

	PRINT 'Processing T_ServObject'
	UPDATE T_ServObject
	SET DESCRIPTION =  'Desc ' + RTRIM(ServObjectCode)
	WHERE DESCRIPTION IS NOT NULL
	AND RTRIM(DESCRIPTION) <> ''
	UPDATE T_ServObject
	SET ServObjAddrLine1 = SUBSTRING('Street ' + RTRIM(ServObjectCode),0,30)
	WHERE ServObjAddrLine1 IS NOT NULL
	AND RTRIM(ServObjAddrLine1) <> ''

	PRINT 'Processing T_Vendor'
	UPDATE T_Vendor
	SET Mnem = RTRIM(CONVERT(CHAR, VendId))
	WHERE Mnem IS NOT NULL
	UPDATE T_Vendor
	SET Info = 'Info ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE Info IS NOT NULL

	PRINT 'Processing T_VendorLog'
	TRUNCATE TABLE T_VendorLog

	PRINT 'Processing T_VendorAddress'
	UPDATE T_VendorAddress
	SET Name = 'Vendor ' + RTRIM(CONVERT(CHAR, VendId))
	UPDATE T_VendorAddress
	SET NameExt = 'NameExt ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE NameExt IS NOT NULL
	AND RTRIM(NameExt) <> ''
	UPDATE T_VendorAddress
	SET Addr = 'Address ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE Addr IS NOT NULL
	AND RTRIM(Addr) <> ''
	UPDATE T_VendorAddress
	SET Addr2 = 'Address2 ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE Addr2 IS NOT NULL
	AND RTRIM(Addr2) <> ''
	UPDATE T_VendorAddress
	SET Addr3 = 'Address3 ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE Addr3 IS NOT NULL
	AND RTRIM(Addr3) <> ''
	UPDATE T_VendorAddress
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEFT(RIGHT(PostCode, 3), 1) = ' '
	UPDATE T_VendorAddress
	SET PostCode = LEFT(PostCode, 4) + ' AA'
	WHERE PostCode IS NOT NULL
	AND RTRIM(PostCode) <> ''
	AND LEN(PostCode) = 6
	AND ISNUMERIC(LEFT(PostCode, 4)) = 1
	AND ISNUMERIC(RIGHT(PostCode, 2)) <> 1
	UPDATE T_VendorAddress
	SET State = 'State ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE State IS NOT NULL
	AND RTRIM(State) <> ''
	UPDATE T_VendorAddress
	SET Phone = '+31 13 7113195'
	WHERE Phone IS NOT NULL
	AND RTRIM(Phone) <> ''
	UPDATE T_VendorAddress
	SET Fax = '+31 13 7113195'
	WHERE Fax IS NOT NULL
	AND RTRIM(Fax) <> ''
	UPDATE T_VendorAddress
	SET Telex = '+31 13 7113195'
	WHERE Telex IS NOT NULL
	AND RTRIM(Telex) <> ''
	UPDATE T_VendorAddress
	SET Email = 'info@' + LOWER(RTRIM(CONVERT(CHAR, VendId))) + '.com'
	WHERE Email IS NOT NULL
	AND RTRIM(Email) <> ''
	UPDATE T_VendorAddress
	SET WebSiteAddr = 'www.' + LOWER(RTRIM(CONVERT(CHAR, VendId))) + '.com'
	WHERE WebSiteAddr IS NOT NULL
	AND RTRIM(WebSiteAddr) <> ''
	UPDATE T_VendorAddress
	SET VATNr = (SELECT
		TOP 1
			VAT
		FROM #HelpVAT hv
		WHERE LEFT(VAT, 2) = (SELECT
			TOP 1
				LEFT(VATNr, 2)
			FROM T_VendorAddress
			WHERE VATNr IS NOT NULL
			AND RTRIM(VATNr) <> ''))
	WHERE VATNr IS NOT NULL
	AND RTRIM(VATNr) <> ''

	PRINT 'Processing T_VendorAddressLog'
	TRUNCATE TABLE T_VendorAddressLog

	PRINT 'Processing T_VendorRelation'
	UPDATE T_VendorRelation
	SET Name = 'Relation ' + RTRIM(CONVERT(CHAR, VendId)) + '-' + RTRIM(CONVERT(CHAR, VendRelCode))
	WHERE Name IS NOT NULL
	AND RTRIM(Name) <> ''
	UPDATE T_VendorRelation
	SET Degree = 'Dr. '
	WHERE Degree IS NOT NULL
	AND RTRIM(Degree) <> ''
	UPDATE T_VendorRelation
	SET FirstName = 'Firstname ' + RTRIM(CONVERT(CHAR, VendId)) + '-' + RTRIM(CONVERT(CHAR, VendRelCode))
	WHERE FirstName IS NOT NULL
	AND RTRIM(FirstName) <> ''
	UPDATE T_VendorRelation
	SET Initials = 'I.N.I.'
	WHERE Initials IS NOT NULL
	AND RTRIM(Initials) <> ''
	UPDATE T_VendorRelation
	SET JobDescription = 'Job ' + RTRIM(CONVERT(CHAR, VendId)) + '-' + RTRIM(CONVERT(CHAR, VendRelCode))
	WHERE JobDescription IS NOT NULL
	AND RTRIM(JobDescription) <> ''
	UPDATE T_VendorRelation
	SET Dept = 'Dept ' + RTRIM(CONVERT(CHAR, VendId)) + '-' + RTRIM(CONVERT(CHAR, VendRelCode))
	WHERE Dept IS NOT NULL
	AND RTRIM(Dept) <> ''
	UPDATE T_VendorRelation
	SET OfficePhone = '+31 13 7113195'
	WHERE OfficePhone IS NOT NULL
	AND RTRIM(OfficePhone) <> ''
	UPDATE T_VendorRelation
	SET OfficeFax = '+31 13 7113195'
	WHERE OfficeFax IS NOT NULL
	AND RTRIM(OfficeFax) <> ''
	UPDATE T_VendorRelation
	SET MobilePhone = '+31 13 7113195'
	WHERE MobilePhone IS NOT NULL
	AND RTRIM(MobilePhone) <> ''
	UPDATE T_VendorRelation
	SET Email = 'relation@' + LOWER(RTRIM(CONVERT(CHAR, VendId))) + '-' + LOWER(RTRIM(CONVERT(CHAR, VendRelCode))) + '.com'
	WHERE Email IS NOT NULL
	AND RTRIM(Email) <> ''
	UPDATE T_VendorRelation
	SET Selection = 'Selection ' + RTRIM(CONVERT(CHAR, VendId)) + '-' + RTRIM(CONVERT(CHAR, VendRelCode))
	WHERE Selection IS NOT NULL
	AND RTRIM(Selection) <> ''
	UPDATE T_VendorRelation
	SET PrivAddr = 'Address ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE PrivAddr IS NOT NULL
	AND RTRIM(PrivAddr) <> ''
	UPDATE T_VendorRelation
	SET PrivAddr2 = 'Address2 ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE PrivAddr2 IS NOT NULL
	AND RTRIM(PrivAddr2) <> ''
	UPDATE T_VendorRelation
	SET PrivAddr3 = 'Address3 ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE PrivAddr3 IS NOT NULL
	AND RTRIM(PrivAddr3) <> ''
	UPDATE T_VendorRelation
	SET PrivPostCode = LEFT(PrivPostCode, 4) + ' AA'
	WHERE PrivPostCode IS NOT NULL
	AND RTRIM(PrivPostCode) <> ''
	AND LEFT(RIGHT(PrivPostCode, 3), 1) = ' '
	UPDATE T_VendorRelation
	SET PrivPostCode = LEFT(PrivPostCode, 4) + ' AA'
	WHERE PrivPostCode IS NOT NULL
	AND RTRIM(PrivPostCode) <> ''
	AND LEN(PrivPostCode) = 6
	AND ISNUMERIC(LEFT(PrivPostCode, 4)) = 1
	AND ISNUMERIC(RIGHT(PrivPostCode, 2)) <> 1
	UPDATE T_VendorRelation
	SET PrivState = 'State ' + RTRIM(CONVERT(CHAR, VendId))
	WHERE PrivState IS NOT NULL
	AND RTRIM(PrivState) <> ''
	UPDATE T_VendorRelation
	SET PrivPhone = '+31 13 7113195'
	WHERE PrivPhone IS NOT NULL
	AND RTRIM(PrivPhone) <> ''

	PRINT 'Clear helper tables'
	DROP TABLE #HelpIban
	DROP TABLE #HelpVAT

	PRINT 'End logging'
	UPDATE ST_T_Anonymized
	SET CompletedAt = GETDATE()
	WHERE id = @AnonymizedId

	PRINT 'Database is anonymized'
	SELECT TOP 1
		IsahDBVersion
		,AnonymizeVersion
	   ,StartedAt
	   ,CompletedAt
	FROM ST_T_Anonymized
	ORDER BY StartedAt DESC
END