Viewing 2 posts - 1 through 2 (of 2 total)
SELECT RangeType,StartDate,EndDate,Comment
FROM dbo.TestTable
WHERE convert(char(10),EndDate,102) >= cast('01 Oct 2013' as datetime)
AND convert(char(10),StartDate,102) <= cast('01 Nov 2013' as datetime)
January 30, 2014 at 7:40 am
#1684675
Everything is right, but there are and other ways how to make your code bullet proof.
January 30, 2014 at 7:02 am
#1684646