Sebastiao Pereira creates a function:
It is very usual to have a set of discrete data points but sometimes it is necessary to estimate values between those points. Is it possible to create a function to do this in SQL Server?
It turns out that the answer is “yes.” Click through to see how.