Home Forums Article Discussions Article Discussions by Author Discuss content posted by Raghavan CV T-SQL query RE: T-SQL query
Knut Boehnert
SSCrazy
Points: 2951
More actions
May 2, 2008 at 1:36 am
#809947
That was a very nice question for a Friday morning.
Another solution would be:
datepart(m,dob) between 1 and 8
and datepart(m,dob) <> 2
and datepart(m,dob) <> 6
Though the single condition definitely beats this solution.