Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SQL Custom Date Range

I need to create an SQL statement that will query from the 19th of the previous month to the 20th of the current month.

Can someone give some examples.

Thanks.

Find more posts tagged with

Accepted answers

All comments

You would have to do this on a month by month basis as there isn't much in terms of using wildcards. One thing that would work in the where clause would be:

Where DateTime Between '2012-08-19' AND '2012-09-20'

This should capture the data you need for that month. Now when it comes to the data, you'd be better off using the view than the _detail, _hourly, _Daily tables, so using the ResponseTime view instead of any of the tables.

Regards,

Matthew Harvey

Loop1 Systems

http://www.loop1systems.com

Quick Links