I prefer this simple and elequent way to generate numbers.

I doesn't generate unnecessary numbers and is easy to understand

[font="Courier New"]CREATE FUNCTION dbo.GetSequence

(

@Start BIGINT,

...

Anthony, nice try but no cigar. I thought of the same thing myself but it doesn't work. It still orders by the alias.

Regarding your second statement this is also...

Wenck, dates are only a problem when not used correctly. Most programmers are inclined to use the easier route of programming ODBC and...