>Must be a bug in 8. I can do an INSERT INTO like you did and it works with the ORDER BY. But if I put the exact same INSERT in a PROC, I get a compilation error. The proc I tried to create:

Ya, That's what I mean. It turns out I don't need the order by (or at least
shouldn't rely on it to insert the rows in order) so I rewrote the function
without order by.

The example was meant to be a reproducable sample but I screwed up on the column types. Thanks for looking.