CREATE PROCEDURE test_insert_delete_2_pk @NR_ROWS INT
AS

DECLARE @test_data TABLE
(
    [column_a] INT NOT NULL,
    [column_b] INT NOT NULL,
	[column_c] VARCHAR(50) NULL
	primary key(column_a, column_b)
)

DECLARE @i INT

SET @i=100

DECLARE @a INT
DECLARE @b INT
DECLARE @c VARCHAR(50)

WHILE (@i <= @NR_ROWS + 100)
BEGIN

	SET @a = @i
	SET @b = @i
	SET @c = 'column_c' + CONVERT(VARCHAR(50), @i)

	INSERT INTO @test_data VALUES
	(@a, @b, @c)

	SET @i = @i + 1

END

DECLARE @timestartinsert DATETIME
SET @timestartinsert = GETDATE()

INSERT INTO dbo.special_table
SELECT * FROM @test_data

DECLARE @timeendinsert DATETIME
SET @timeendinsert = GETDATE()

INSERT INTO dbo.TestRuns VALUES ('Insertion on special_table', @timestartinsert, @timeendinsert)

DECLARE @test_run_id INT
SET @test_run_id = (SELECT TestRunID from dbo.TestRuns WHERE StartAt=@timestartinsert)

DECLARE @test_id INT
SET @test_id = (SELECT TestID FROM dbo.Tests WHERE Name = 'insert')

DECLARE @table_id INT
SET @table_id = (SELECT TableID FROM dbo.Tables where Name = 'special_table')

INSERT INTO dbo.TestTables VALUES(@test_id, @table_id, @NR_ROWS, @test_run_id)

WAITFOR DELAY '00:00:01'

SET @i = 100

DECLARE @timestartdelete DATETIME
SET @timestartdelete = GETDATE()

WHILE (@i <= @NR_ROWS + 100)
BEGIN

	SET @a = @i

	DELETE FROM dbo.special_table WHERE @a = column_a

	SET @i = @i + 1

END

DECLARE @timeenddelete DATETIME
SET @timeenddelete = GETDATE()

INSERT INTO dbo.TestRuns VALUES ('Deletion on special_table', @timestartdelete, @timeenddelete)

DECLARE @test_run_id_del INT
SET @test_run_id_del = (SELECT TestRunID from dbo.TestRuns WHERE StartAt=@timestartdelete)

DECLARE @test_id_del INT
SET @test_id_del = (SELECT TestID FROM dbo.Tests WHERE Name = 'delete')

DECLARE @table_id_del INT
SET @table_id_del = (SELECT TableID FROM dbo.Tables where Name = 'special_table')

INSERT INTO dbo.TestTables VALUES(@test_id_del, @table_id_del, @NR_ROWS, @test_run_id_del)

GO