Todd Young-359443 (10/12/2012)
My group is having a discussion as to performance hits when a UDF is used as a macro -IE it accesses no tables, is passed no rows. Some simple logic and a calculation on a date/time
value.
To add to what Lowell has posted, "One test is worth a thousand expert opinions". Please see the following article for what a difference an "iSF" can make over such a Scalar UDF.
http://www.sqlservercentral.com/articles/T-SQL/91724/
--Jeff Moden
Change is inevitable... Change for the better is not.