SET NOCOUNT ON

	DELETE FROM LNK_JOB_CONTRACT_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_CONTRACT_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_CONTRACT_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Contract(NULL, NULL)
	GO
	
	DELETE FROM LNK_JOB_LOCATION_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_LOCATION_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_LOCATION_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Location(NULL, NULL)
	GO

	DELETE FROM LNK_JOB_DEPARTMENT_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_DEPARTMENT_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_DEPARTMENT_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Department(NULL, NULL)
	GO

	DELETE FROM LNK_JOB_PAY_GRADE_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_PAY_GRADE_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_PAY_GRADE_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Pay_Grade(NULL, NULL)
	GO

	DELETE FROM LNK_JOB_CONTRACT_TYPE_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_CONTRACT_TYPE_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_CONTRACT_TYPE_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Contract_Type(NULL, NULL)
	GO

	DELETE FROM LNK_JOB_CONTRACT_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_JOB_CONTRACT_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_JOB_CONTRACT_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Job_Contract(NULL, NULL)
	GO

	DELETE FROM LNK_PAY_PAY_GRADE_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_PAY_PAY_GRADE_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_PAY_PAY_GRADE_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Pay_Pay_Grade(NULL, NULL)
	GO

	DELETE FROM LNK_PAY_SPINAL_COLUMN_POINT_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_PAY_SPINAL_COLUMN_POINT_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_PAY_SPINAL_COLUMN_POINT_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Pay_Spinal_Column_Point(NULL, NULL)
	GO

	DELETE FROM LNK_CONTRACT_DEPARTMENT_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_CONTRACT_DEPARTMENT_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_CONTRACT_DEPARTMENT_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Contract_Department(NULL, NULL)
	GO

	DELETE FROM LNK_CONTRACT_LOCATION_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_CONTRACT_LOCATION_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_CONTRACT_LOCATION_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Contract_Location(NULL, NULL)
	GO

	DELETE FROM LNK_CONTRACT_CONTRACT_TYPE_VIRTUAL
	GO
	DBCC CHECKIDENT (LNK_CONTRACT_CONTRACT_TYPE_VIRTUAL, RESEED, 1)
	GO
	INSERT INTO LNK_CONTRACT_CONTRACT_TYPE_VIRTUAL(Left_Join, Right_Join, Start_Date, End_Date)
	SELECT Left_Join, Right_Join, Start_Date, End_Date FROM fn_Contract_Contract_Type(NULL, NULL)
	GO
	
	SET NOCOUNT OFF