Sunday, December 10, 2023

ssrs Reporting Services Cannot read next row

 Erhalte diesen Fehler durch die Where Klausel: where C>GetDate()-@Tage

umgestellt auf where C>@Von funktioniert


FEHLER SQL GESAMT:

declare @tage as int=100; declare @Anz as int =0

select  errlevel,namespace as nspace,title,msg,count(*) as anz  from tLog 

where C>GetDate()-@Tage

group by errlevel, namespace, title,msg 

having count(*)>@Anz 

order by errlevel,count(*) desc

No comments: