select * from TEST_GRADE_DATE where
((begindate between convert(datetime,'2012-10-12') and convert(datetime,'2012-10-18'))
or (enddate between convert(datetime,'2012-10-12') and convert(datetime,'2012-10-18')))
select * from TEST_GRADE_DATE where
((begindate between convert(datetime,'2012-10-12') and convert(datetime,'2012-10-18'))
or (enddate between convert(datetime,'2012-10-12') and convert(datetime,'2012-10-18')))