SET LANGUAGE turkish;

WITH dates (d)

AS (SELECT DATEADD(d, N - 1, CAST('20230101' AS DATE))

FROM

(

SELECT TOP (366)

ROW_NUMBER() OVER (ORDER BY t1.object_id) AS N

FROM master.sys.all_columns t1

CROSS JOIN master.sys.all_columns t2

) tmp )

SELECT d,

DATENAME(MONTH, d) + ' '

+ CAST(DATEPART(WEEK, d) - DATEPART(WEEK, DATEFROMPARTS(YEAR(d), MONTH(d), 1)) + 1 AS VARCHAR) + '.haftasi'

FROM dates;