BaseVehicleID Population

gistfile1.sql

DECLARE @CursorVar1 CURSOR
DECLARE @CurrentVehicle int
DECLARE @CurrentYear int
DECLARE @CurrentMake int
DECLARE @CurrentModel int

SET @CursorVar1 = CURSOR SCROLL DYNAMIC
FOR
select AAIABaseVehicleID, AAIAYearID, AAIAMakeID, AAIAModelID from AAIABaseVehicle

OPEN @CursorVar1

FETCH NEXT FROM @CursorVar1 INTO @CurrentVehicle, @CurrentYear, @CurrentMake, @CurrentModel
WHILE @@FETCH_STATUS = 0
BEGIN
	Update Application set BaseVehicleID = @CurrentVehicle
	WHERE FromYear = @CurrentYear AND AAIAMakeID = @CurrentMake AND AAIAModelID = @CurrentModel
	FETCH NEXT FROM @CursorVar1 INTO @CurrentVehicle, @CurrentYear, @CurrentMake, @CurrentModel
END
CLOSE @CursorVar1
DEALLOCATE @CursorVar1