Update using 2 variables

DECLARE @StartYear As int
DECLARE @EndYear As int
DECLARE @Counter As Int
DECLARE @MonthCounter As Int

Set @StartYear = 2003
Set @EndYear = 2005
SET @Counter = @StartYear
 
 
CREATE TABLE LV_Test (Month1 INT) 
 WHILE @Counter <> @EndYear + 1
 BEGIN
 ALTER TABLE LV_Test ADD NewCol INT
 EXEC sp_rename 'LV_Test.[NewCol]', @counter, 'COLUMN'
  SET @Counter = @Counter + 1
 END

SET @Counter = 1
WHILE @Counter <> 13
BEGIN
 INSERT INTO #YearTable(Month_) Values (@Counter)
 SET @Counter = @Counter + 1
END

SET @Counter = @StartYear
SET @MonthCounter = 1
Print @Counter
Print @MonthCounter
 
 WHILE @MonthCounter <> 13 
 BEGIN
      UPDATE LV_Test
 
 ----------------------------------It is at this set 
      SET @StartYear = (SELECT  Count(bc.VersionNo) As Month1   
      FROM BasicContract bc
             WHERE bc.ContractNumber Not In('0UZ00','0UU00','0Temp','0XX00','') AND bc.BusinessUnitName <> '' 
      And Year(CreateDate) = @StartYear And Month(CreateDate) = @MonthCounter 
      GROUP BY Month(CreateDate)
         ) 
          WHERE Month1 = @MonthCounter

      Set @MonthCounter = @MonthCounter + 1
   END

SELECT * FROM LV_Test
DROP TABLE LV_Test