title: How to I combine a sql server 2005 datetime and an integer field
body: <p>I have 2 fields in a table on sql server 2005.  One is a datetime field where the date is correct and all the times are 12:00:00am.  The second field is a 3 to 4 digit integer that represents the hours and minutes of the transaction in a military time format.  I'm trying to create a view that will, among other things, show those 2 fields combined in one datetime field.  Is it possible?  I'm going to need to do some time interval calculations and it would be easier to deal with them if they were together.</p>