Mendapatkan nama hari dan tanggal dalam 1 tahun di SQL Server

 SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num) as Tanggal,

DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) as Nama_Hari

FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n

order by DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num) desc

* WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'