• I like Eirikur Eiriksson's solution.

    A little more information can be found, http://stackoverflow.com/questions/7289753/combining-date-and-time-fields-to-datetime-sql-server-2008