1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
create table dbo.testlog
( adip varchar(15),
datelog datetime)
insert into dbo.testlog values ('11.11.11.11',getdate() )
insert into dbo.testlog values ('11.11.11.11',getdate() )
insert into dbo.testlog values ('11.11.11.11',getdate() )
insert into dbo.testlog values ('11.11.11.11',dateadd(day,-1,getdate()) )
insert into dbo.testlog values ('11.11.11.11',dateadd(day,-1,getdate()) )
insert into dbo.testlog values ('11.11.11.11',dateadd(day,-2,getdate()) )
insert into dbo.testlog values ('11.11.11.11',dateadd(day,-2,getdate()) )
select * from testlog
declare @param_nb integer, @param_periode varchar(10)
set @param_periode = 'jour'
set @param_nb = 3
if @param_periode = 'jour'
begin
select count(*)
from testlog
where convert(datetime, left(convert(varchar(10),datelog,101),10))
> convert(datetime, left(convert(varchar(10),dateadd(day, -@param_nb, getdate()),101),10))
group by convert(datetime, left(convert(varchar(10),datelog,101),10))
order by convert(datetime, left(convert(varchar(10),datelog,101),10)) desc
end |
Partager