title: How to calculate difference in hours (decimal) between two dates in SQL Server?
body: <p>I have to calculate the difference in hours (decimal type) between two dates in SQL Server 2008.</p>
  
  <p>I couldn't find any useful technique to convert datetime to decimal with 'CONVERT' on MSDN.
  <br />Can anybody help me with that?</p>
  
  <p>UPDATE:<br />
  To be clear, I need the fractional part as well (thus decimal type). So from 9:00 to 10:30 it should return me 1.5.</p>