DECLARE @DateTest AS TABLE (Datex DATE) 
DECLARE @DURATION INT
SET @DURATION = 0 
WHILE (@DURATION > -1999)
BEGIN
INSERT INTO @DateTest
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) + @DURATION, 0) AS Datex
SET @DURATION = @DURATION - 1
END 

SELECT DAY (Datex) AS DAYNO
,MONTH (Datex) AS MONTHNO
,YEAR (Datex) AS YEARNO
,CASE WHEN (MONTH (Datex) IN (1,2,3)) THEN CAST (YEAR (Datex) AS VARCHAR(6)) + '01' END AS QUARTERNO
,CASE WHEN (MONTH (Datex) IN (4,5,6)) THEN CAST (YEAR (Datex) AS VARCHAR(6)) + '02' END AS QUARTERNO
,CASE WHEN (MONTH (Datex) IN (7,8,9)) THEN CAST (YEAR (Datex) AS VARCHAR(6)) + '03' END AS QUARTERNO
,CASE WHEN (MONTH (Datex) IN (10,11,12)) THEN CAST (YEAR (Datex) AS VARCHAR(6)) + '04' END AS QUARTERNO

FROM @DateTest;

SELECT DAY (Datex) AS DAYNO
,MONTH (Datex) AS MONTHNO
,YEAR (Datex) AS YEARNO
,STR(DATEPART(year,Datex),4,0) + REPLACE(STR(DATEPART(q,Datex),4,0), ' ', '0') AS QUARTERNO
FROM @DateTest;