use zadaca
DECLARE @pocDatum DATEtime = '01/01/2000'
DECLARE @zavrsniDatum DATEtime = '12/31/2020'

DECLARE @pomocniDatum datetime
SET @pomocniDatum = @pocDatum

SET LANGUAGE Croatian;

WHILE @pomocniDatum <= @zavrsniDatum
BEGIN

 INSERT INTO dDatum VALUES (
  (CONVERT (int,@pomocniDatum,112)),--sifDatum
  @pomocniDatum,--datum
  CONVERT (char(10),@pomocniDatum,104),--danMjGod
  Day(@pomocniDatum), --dan
  DATENAME(weekday,@pomocniDatum), --nazivDan
  DATENAME(dayOfYear,@pomocniDatum) ,--rbrDanUGod
  DATENAME(weekday,@pomocniDatum) ,--rbrDanUTjednu
  DATENAME(week,@pomocniDatum) ,--rbrTjedanUGodini
  Month(@pomocniDatum), --mjesec
  DATENAME(mm,@pomocniDatum), --nazivMjeseca
  DATENAME(qq,@pomocniDatum) ,  --kvartal
  Year(@pomocniDatum),--godina
 cast (0 as char(1)) , --praznik
  CASE  WHEN  DATENAME(weekday,@pomocniDatum) IN (1, 2, 3,4,5) THEN cast(1 as char(1))
   ELSE cast(0 as char(1))
  END, --radniDan

  (case

  when month(@pomocniDatum)= 1 and day(@pomocniDatum)= 1 then 'Nova godina'
  when month(@pomocniDatum) = 1 and day(@pomocniDatum)= 6 then 'Sveta tri kralja'
  when month(@pomocniDatum) = 2 and day(@pomocniDatum)= 14 then 'Valentinovo'
when month(@pomocniDatum) = 5 and day(@pomocniDatum) = 1 then 'Praznik rada'
when month(@pomocniDatum) = 6 and day(@pomocniDatum) = 22 then 'Dan antifašističke borbe'
when month(@pomocniDatum) = 6 and day(@pomocniDatum) = 25 then 'Dan državnosti'
when month(@pomocniDatum) = 8 and day(@pomocniDatum) = 15 then 'Velika gospa'
when month(@pomocniDatum) = 10 and day(@pomocniDatum) = 8 then 'Dan nezavisnosti'
when month(@pomocniDatum) = 11 and day(@pomocniDatum) = 1 then 'Dan svih svetih'
when month(@pomocniDatum) = 12 and day(@pomocniDatum) = 25 then 'Božić'
when month(@pomocniDatum) = 12 and day(@pomocniDatum) = 26 then 'Sveti Stjepan'
end ),


 (case when convert(varchar(5),@pomocniDatum,110) between '03-21' and '06-20' then 'proljeće'
	when convert(varchar(5),@pomocniDatum,110) between '06-21' and '09-22' then 'ljeto'
	when convert(nvarchar(5),@pomocniDatum,110) between '09-23' and '12-20' then 'jesen'
	else 'zima'
 end)
 )

 SET @pomocniDatum = DateAdd(d, 1, @pomocniDatum)
END