I have to insert data into the table at the end of each quarter for the past 10 years.

For now i am able to insert data for the past 10 years.but i need it for quarterly.

-- Set @EOM to end-of-last-quarter date

DECLARE @EOM datetime

SET @EOM = CAST(YEAR(GETDATE()) as varchar(4)) + '-'

+ CAST((MONTH(GETDATE())-1) / 3 * 3 + 1 AS varchar)

+ '-01'

SET @EOM = DATEADD(day,-1,@EOM)

--SET @EOM = '03-31-2010' -- For Testing Purpose

--PRINT @EOM

--Table to Include Last 10 years Worth of Sales Amt data at the End of Each Year

Declare @StartDate datetime

Declare @EndDate datetime

SET @StartDate = CONVERT(DATETIME, CAST(YEAR(@EOM)-10 as varchar(4)) + '-01-01',120)

SET @EndDate = DATEADD(year,1,@StartDate-1)

--PRINT @Startdate

--PRINT @EndDate

--Loop to retrieve past 10 years worth of Data at the end of each year

WHILE @EndDate < @EOM

BEGIN

SET @StartDate = DATEADD(Year,1,@StartDate)

SET @EndDate = DATEADD(Year,1,@EndDate)

IF @EndDate > @EOM

SET @EndDate=@EOM

--Insert into Table ---- @EndDate

-- PRINT CONVERT(varchar(11),@StartDate,113) + ' - ' + CONVERT(varchar(11),@EndDate,113)

End