WHEN 'F1' THEN 'usp_F1_ImportScript'
                       WHEN 'F2' THEN 'usp_F2_ImportScript'

Create PROC [dbo].[usp_F1_ImportScript]

AS
 
-- Check if template table already exists and if it does then delete the table
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CSVTest]') AND type in (N'U'))
DROP TABLE dbo.CSVTest

-- Create a new template table
CREATE TABLE CSVTest
(TCODE Varchar (5),
PSPNR Varchar (255),
ZZLOC Varchar (255),
ZZPLN_QTY Varchar (255))

-- Load data into table
BULK
INSERT CSVTest
FROM 'C:\Users\Desktop\F1_Book1.csv' 
WITH
(
FIRSTROW = 2, -- Removes the Header Row
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Create PROC [dbo].[usp_F1_ImportScript]

AS
 
-- Check if template table already exists and if it does then delete the table
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VCOST]') AND type in (N'U'))
DROP TABLE dbo.VCOST

-- Create a new template table
CREATE TABLE VCOST
(TCODE Varchar (4),
PSPNR Varchar (25),
ZZOBJ_NO Varchar (10))

-- Load data into table
BULK
INSERT VCOST
FROM 'C:\Users\Desktop\F2_Book2.csv' 
WITH
(
FIRSTROW = 2, -- Removes the Header Row
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

CREATE PROCEDURE [dbo].[usp_FilePicker] (@FileName VARCHAR(255))

AS
--check if @FileName is null
IF @FileName IS NULL
BEGIN
SELECT 'No Files Match' AS ERROR
RETURN
END
--Declare our dynamic sql holder
DECLARE @Cmd VARCHAR(MAX)

-- set up exec command
SET @Cmd = 'EXEC ' 

--Get the stored procedure to run add when statements for each
SET @Cmd = @Cmd + CASE @FileName
                       WHEN 'F1_Book1.csv' THEN 'usp_F1_ImportScript'
                       WHEN 'F2_Book2.csv' THEN 'usp_F2_ImportScript'
					   END
                       
--Execute the Stored Procedure           
EXEC( @Cmd )

EXEC usp_FilePicker 'F1_Book2.csv'
EXEC usp_FilePicker 'F2_Book1.csv'