Good Article, Just I was wondering about scalar function, the difference between having read from table inside and don't. In the first example where you're using dbo.fn_SumRangeOfNumbers() I guess you're reading from tail Numbers table. What will happend if you change the code and instead of that put the formula:
(SecondNumber*(SecondNumber +1))/2-(FirstNumber*(FirstNumber +1))/2
I think will return the same result, but what's happening with the reads then? are the same (13) or 1 like in Name Format function?