One of our developers is adding a lot of UDF's (some of them complex), and then referencing them in select lists. Others are very simple which IMO would be better done inline in the sql. Are there any resources which explain how sql server handles UDF's ?
For information have a look at this article about UDFs -http://builder.com.com/article.jhtm...UCEPTQQACQCFFQ?id=u00320020206rsh01.htm&vf=ra HTH Satya SKJ
There is a good section on this topic on pages 617-628 of Inside Microsoft SQL Server 2000 by Kalen Delaney. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com
