DECLARE @ParameterID2 NVARCHAR(50),@HouseTypeNum2 INT
DECLARE cur CURSOR FOR SELECT ParameterID2 FROM #Temp_Test2
OPEN cur
FETCH NEXT FROM cur INTO @ParameterID2
WHILE @@FETCH_STATUS=0
BEGIN
SELECT @HouseTypeNum2=HouseTypeNum FROM #Temp_Value WHERE ParameterID=@ParameterID2
UPDATE #Temp_Test2 SET HouseTypeNum2=@HouseTypeNum2 WHERE ParameterID2=@ParameterID2
FETCH NEXT FROM cur INTO @ParameterID2
END
CLOSE cur
DEALLOCATE cur