December 17th, 2003, 03:47 PM
Returning alternate rows from a query
Any thoughts about how one could return alternate records in an MS SQL
query hitlist? The specific application is that I'm performing a query that
returns a group of records in a date range -- say, every "Monday" record. I'd like
to have the query be able to select every other Monday instead, if the
user so desires.
Thanks in advance!
- Tom Tedeschi
December 17th, 2003, 04:06 PM
use DATEPART(ww...) to get odd/even week numbers
December 17th, 2003, 04:09 PM