SQL haftalık aylık listeleme SQL weekly month listing

select top 20
OwnerCode as Adi,
convert(varchar(10), CreateDate, 104) as KayitTarihi,
convert(nvarchar(2),(datepart(day, CreateDate - 1) / 7 + 1)) + '. Hafta ' +
case datename(mm, [CreateDate]) when 'January' then 'Ocak' when 'February' then 'ubat' when 'March' then 'Mart' when 'April' then 'Nisan' when 'May' then 'Mays' when 'June' then 'Haziran' when 'July' then 'Temmuz' when 'August' then 'Austos' when 'September' then 'Eyll' when 'October' then 'Ekim' when 'November' then 'Kasm' when 'December' then 'Aralk' end
as HaftaAy
from Table
where
(datepart(day, CreateDate - 1) / 7 + 1) = 1
or (datepart(day, CreateDate - 1) / 7 + 1) = 2
or(datepart(day, CreateDate - 1) / 7 + 1) = 3
or (datepart(day, CreateDate - 1) / 7 + 1) = 4
group by (datepart(day, CreateDate - 1) / 7 + 1),CreateDate,OwnerCode
order by max(datepart(month,CreateDate)),(datepart(day, CreateDate - 1) / 7 + 1)

-- Ertürk Polat