USE ExpensiveCars
GO

CREATE PROCEDURE RunViewTestsProc
AS
BEGIN
	DECLARE @x int
	SELECT @x = TestRunID FROM TestRuns WHERE Description = 'View'

	DECLARE @viewName1 VARCHAR(50)
	SELECT @viewName1 = Name FROM Tests WHERE TestId = 13

	DECLARE @ds1 DATETIME
	DECLARE @de1 DATETIME
	SET @ds1 = GETDATE()
	EXECUTE @viewName1
	SET @de1 = GETDATE()
	INSERT INTO TestRunViews(TestRunID, ViewID, StartAT, EndAt) VALUES (@x, 4, @ds1, @de1)


	DECLARE @viewName2 VARCHAR(50)
	SELECT @viewName2 = Name
	FROM Tests
	WHERE TestId = 14

	DECLARE @ds2 DATETIME
	DECLARE @de2 DATETIME
	SET @ds2 = GETDATE()
	EXECUTE @viewName2
	SET @de2 = GETDATE()
	INSERT INTO TestRunViews(TestRunID, ViewID, StartAT, EndAt) VALUES (@x, 5, @ds2, @de2)


	DECLARE @viewName3 VARCHAR(50)
	SELECT @viewName3 = Name
	FROM Tests
	WHERE TestId = 15

	DECLARE @ds3 DATETIME
	DECLARE @de3 DATETIME
	SET @ds3 = GETDATE()
	EXECUTE @viewName3
	SET @de3 = GETDATE()
	INSERT INTO TestRunViews(TestRunID, ViewID, StartAT, EndAt) VALUES (@x, 6, @ds3, @de3)
END

-- EXECUTE RunViewTestsProc