I was in need of a sequence function for SQL Server and this article does the trick:
As I implemented this example figure 4 with success:
However I need it to increment by one each time it's called currently if I run this function like this:
SELECT id FROM fn_sequence(1,1)
It gives me a start value and end value of one which is what I want however I'd like to increment by one each time it's called - is this possible!