I'm using MS SQL 2005, and I want to check two dates for equality, but ignoring the time part.
I know I can make use of DATEDIFF, but am concerned that it may be slow - this SP gets used in the DB a lot!
Any suggestions?
Edit: David Andres' comment:
'"comparison" includes much more than equality'made me realise that I didn't make my question clear enough - I am actually just checking for equality, that is all.