Your ddl does not work at all. You have a lot of errors in there. You are setting identity insert but none of the tables have an identity column and many other issues. I cleaned this up as best as I could. This will at least generate the tables but you have primary key violations. Can you clean this up and test it on a test database so it will create your test data? Also, I would highly recommend not using prefixes (LF), special characters ($) or spaces in object names. It really makes it painful to work with.

/*

drop table [LF$Business Volume]

drop table [LF$User Setup]

drop table [LF$Customer]

*/

CREATE TABLE [dbo].[LF$Business Volume](

[Code] [varchar](20) NOT NULL,

CONSTRAINT [LF$Business Volume$0] PRIMARY KEY CLUSTERED

(

[Code] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

GO

CREATE TABLE [dbo].[LF$User Setup](

[User ID] [varchar](20) NOT NULL,

[Department] [varchar](10) NOT NULL,

CONSTRAINT [LF$User Setup$0] PRIMARY KEY CLUSTERED

(

[User ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

)

GO

CREATE TABLE [dbo].[LF$Customer](

[No_] [varchar](20) NOT NULL,

[Salesperson Code] [varchar](10) NOT NULL,

[Current Business Volume] [varchar](20) NOT NULL,

[Potential Business Volume] [varchar](20) NOT NULL,

CONSTRAINT [LF$Customer$0] PRIMARY KEY CLUSTERED

(

[No_] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100)

)

GO

--===== Insert the test data into the test table

INSERT INTO [LF$Business Volume]

(Code)

SELECT 'A + 5 MIO' UNION ALL

SELECT 'B 2 - 5 MIO' UNION ALL

SELECT 'C 0,5 - 2 MIO' UNION ALL

SELECT 'D - 0,5 MIO' UNION ALL

SELECT 'E NEUTRAL' UNION ALL

SELECT 'X UØNSKET'

--===== Insert the test data into the test table

INSERT INTO [LF$User Setup]

([User ID], Department)

SELECT 'JHP','LANDBRUG' UNION ALL

SELECT 'STE','LANDBRUG' UNION ALL

SELECT 'TRO','LANDBRUG' UNION ALL

SELECT 'JQH','LANDBRUG' UNION ALL

SELECT 'PAS','LANDBRUG' UNION ALL

SELECT 'MQW','LANDBRUG' UNION ALL

SELECT 'NEX','TRANSPORT' UNION ALL

SELECT 'SLO','TRANSPORT' UNION ALL

SELECT 'LLY','TRANSPORT' UNION ALL

SELECT 'KAL','TRANSPORT' UNION ALL

SELECT 'TST','TRANSPORT' UNION ALL

SELECT 'SER','TRANSPORT' UNION ALL

SELECT 'LKA','FORHANDLER' UNION ALL

SELECT 'GEC','FORHANDLER' UNION ALL

SELECT 'LMO','FORHANDLER' UNION ALL

SELECT 'TSV','FORHANDLER' UNION ALL

SELECT 'JPI','KREDIT' UNION ALL

SELECT 'JRY','KREDIT' UNION ALL

SELECT 'JVA','KREDIT' UNION ALL

SELECT 'SSS','KREDIT'

--===== Insert the test data into the test table

INSERT INTO [LF$Customer]

(No_, [Salesperson Code], [Current Business Volume], [Potential Business Volume])

SELECT '209517','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209519','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209658','GEC','B 2 - 5 MIO','E NEUTRAL' UNION ALL

SELECT '209528','GEC','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209661','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209658','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209529','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209539','GEC','B 2 - 5 MIO','E NEUTRAL' UNION ALL

SELECT '209523','GEC','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209544','LKA','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209542','LKA','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209670','LKA','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209548','LKA','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209657','LKA','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209545','LKA','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209532','LMO','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209540','LMO','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209536','TST','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209543','LLY','C 0,5 - 2 MIO','E NEUTRAL' UNION ALL

SELECT '209547','LLY','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209651','SER','E NEUTRAL','X UØNSKET' UNION ALL

SELECT '209516','STE','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209516','STE','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209524','STE','C 0,5 - 2 MIO','E NEUTRAL' UNION ALL

SELECT '209524','STE','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209659','MQW','E NEUTRAL','D - 0,5 MIO' UNION ALL

SELECT '209659','MQW','E NEUTRAL','D - 0,5 MIO' UNION ALL

SELECT '209664','JQH','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209525','JQH','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209664','JQH','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209525','JQH','D - 0,5 MIO','E NEUTRAL' UNION ALL

SELECT '209531','JHP','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209546','JHP','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209666','JHP','C 0,5 - 2 MIO','E NEUTRAL' UNION ALL

SELECT '209531','JHP','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209546','JHP','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209666','JHP','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209531','JPI','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209546','JPI','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209666','JPI','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209531','JPI','E NEUTRAL','E NEUTRAL' UNION ALL

SELECT '209546','JPI','E NEUTRAL','E NEUTRAL'