Remove LoadTestRuns

gistfile1.sql

DECLARE @LoadTestRunId int

DECLARE db_cursor CURSOR FOR  
	SELECT LoadTestRunId [LoadTestRunId] FROM [LoadTest2010].[dbo].[LoadTestRun]

OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @loadTestRunId   

WHILE @@FETCH_STATUS = 0   
BEGIN   
       EXECUTE [LoadTest2010].[dbo].[Prc_DeleteDataCollectorLogs] @LoadTestRunId
       EXECUTE [LoadTest2010].[dbo].[Prc_DeleteLoadTestRun] @LoadTestRunId

       FETCH NEXT FROM db_cursor INTO @LoadTestRunId   
END   

CLOSE db_cursor   
DEALLOCATE db_cursor