Posted by Robert on 02/02/06 00:50

Maybe this is a lot easier to do than I first thought:

select count(*) from application_errors
where error_message like 'Time%'
and error_time >= '1Jan2004' and error_time < '1Jan2005'
group by month (error_time)

This saves me a lot of work. Now, if I could figure out how to span years
and still group by months...


"Robert" <robert.j.sipe@boeing.com> wrote in message
news:Iu152F.BBL@news.boeing.com...
>I would like to run a report for each month over two years. I am currently
>using a date range like this. Then manually substitute the error_time
>bounds for each month and rerun the query. How can I script this so I can
>programmatically perform the substitution in a loop. Thanx in advance.
>
>
> select count(*) from application_errors
> where error_message like 'Time%'
> and error_time >= '1Apr2004' and error_time < '1May2004'
>

• Next in forum: Re: SQL Server 2005: setup problem
• Prev in forum: Re: Getting the database name in Server-Side trace event
• Thread view: Re: Monthly date range substitution

[Reply to this message]