title: combining Date and Time fields to DateTime, SQL Server 2008
body: <p>Ok - I've asked a few people and there has got to be an easy way to do this.... </p>
  
  <pre><code>declare @Date date
  declare @Time time 
  declare @datetime datetime
  
  select @Date = convert(Date,GetDate()) 
  select @Time = convert(Time,GetDate())
  
  select @Date, @Time, @Date + @Time (+ operator fails!)
  </code></pre>
  
  <p>Do I really have to: 
  1) convert to a string, then convert to datetime field?
  2) use DateAdd and DatePart to add hours first then minutes, then seconds.....</p>