UDFs have many restrictions but I find them quite useful. I frequently
write stuff like the following, where the UDFs contains all kinds of
nasty code. You can even nest UDFs, although I try not to get carried
away with it.
select ...
from myUdfA(@params)
join myUdfB(@params)
on ...