I'd like to see an example on when to use that.
But the thing is, a function is allowed to output a non-deterministic result. It just doesn't support temporary tables which is a different matter. And it doesn't allow side-effects.
CREATE FUNCTION dbo.FN_WhichDateIsToday()
Thank you for the small hint. 🙂
Andre Guerreiro Neto