Difference of two date time in sql server .... I used this for a calculated column, but you could trivially ...
stackoverflow.com