last date in database make a week

See more:

SQL-Server

hi,


I am using a query for showing weekly data.but i want to start week from latest entry of date in database.how to do this??

my query is given below:

select count(MissedLogParam) as MissedLogParam,convert(varchar(12),DATEADD(wk, DATEDIFF(wk,9, Server_DateTime),10),106)
 as 'Server_DateTime'
 from DeviceAlarmLog where Server_DateTime>=DATEADD(dd,-7,Server_DateTime) and IsAbsent=1
 group by DATEADD(wk, DATEDIFF(wk,9, Server_DateTime),10)
 order by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)
 select count(MissedLogParam)  as 'TotalAlarm' from DeviceAlarmLog
group by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)
order by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)