time) END END IF(@MaxPopulationYear < @NewMaxPopulationYear) BEGIN - @MaxPopulationYear から @NewMaxPopulationYear を生成します SELECT ...

, 1, @time)
                    END
            END
            IF(@MaxPopulationYear < @NewMaxPopulationYear)
            BEGIN
                -- @MaxPopulationYear から @NewMaxPopulationYear を生成します
                SELECT @time = DATEADD(Year, 1, @MaxPopulationYear)
                WHILE @time < DATEADD(Year, 1, @NewMaxPopulationYear)
                BEGIN
                    INSERT INTO #temp