title: SQL Server: From 2008 To 2014 :-The data types datetime and time are incompatible in the add operator. Any other solution?
body: <p>I am migrating from SQL Server 2008 To 2014 and I get an error </p>
  
  <blockquote>
    <p>The data types datetime and time are incompatible in the add operator.</p>
  </blockquote>
  
  <p>I figured out the solution convert time to DateTime, but I have changes in many stored procedures and views.</p>
  
  <p>Is there any other solution for above problem?</p>