declare @userID varchar(15)
declare @YearRef datetime
declare @PastYearData varchar(15)
declare @CurrentYearData varchar(6)
declare @updateyear datetime
declare @updateyearplus datetime
select @updateyear = CONVERT(DATETIME, '01/01/2003', 101)
select @updateyearplus = CONVERT(DATETIME, '12/31/2003', 101)
DECLARE CUR_updateData SCROLL CURSOR FOR
SELECT userID,
YearRef,
PastYearData,
CurrentYearData
FROM table_name
Where (YearRef >= @updateyear) and (YearRef <= @updateyearplus)
OPEN CUR_updateData
FETCH NEXT FROM CUR_updateData
INTO @userID,
@YearRef,
@PastYearData,
@CurrentYearData
while @@fetch_status = 0
BEGIN
select @YearRef = DATEADD(year, 1,@YearRef)
insert into table_name (userID,YearRef,PastYearData,CurrentYearData)
values (@userID,@YearRef,@CurrentYearData,null)
FETCH NEXT FROM CUR_updateData
INTO @userID,
@YearRef,
@PastYearData,
@CurrentYearData
END
CLOSE CUR_updateData
DEALLOCATE CUR_updateData
Hope this helps