Interesting approach - we use Convert, relying on the fact that DateTime values are internally stored as floating-point values, with every whole number representing a day:
SET @DateWithoutTime = Convert(DateTime, Floor(Convert(Float, @OriginalDate)))
Any idea which is faster? I don't have time to test right now, but I'm quite curious 🙂
http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.