title: SQL Server 2012, Concat a Date with a Time column to insert into a DateTime column in another table
body: <p>In SQL Server 2012 ... I have two column in a table, 
  TransactionDate(date,null) and 
  TransactionTime(time, null)</p>
  
  <p>I need to concatenate them together to insert into another table's column which is a Datetime datatype.</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks in advance.</p>