Is there a clean and simple method of formatting an integer which is a count of a whole number of minutes into a decimal represnetation of hours and minutes. It's a great shame that there is not such thing as a timespan in T-SQL to support this.
Just to be clear what i mean by this is if i have 70 minutes, i want to covert it into a representation of 1hour and 10 minutes i.e. 1.10. (i'll also want to keep it as a varchar or something to ensure that the trailng zero is kept in place).
Is there anyway that this could be created as a custom function in SQL so that it can be resused from different queries?