You can call a UDF from a SELECT statement. You can join to a UDF. SQL Server 2000 has a new Table data type that lets you declare local variables as type table. The table type is available only ...