Jako de Wet (2/26/2014)
Thanks KevinWill read through it tomorrow.
Interested to read how to get info back in a query that requires more than a plain join.
Do the functions have the word "BEGIN" in them? If they do and they're in the FROM clause, then they are mTVFs (Multi-Statement Table Valued Functions) and not iTVFs (Inline Table Valued Functions). mTVFs are usually worse than even scalar functions.
--Jeff Moden
Change is inevitable... Change for the better is not.