However, you can greatly improve the performance by converting the scalar function to a table-valued function and using a CROSS APPLY in the query.

Welcome to another exciting installment of “Deep Thoughts by Jack Handy T-SQL Theory questions that only Maxer seems to care about…”If trees could scream, would we be so cavalier about ...

If you find yourself doing this a lot in Microsoft SQL Server, you can get better performance by using a table-valued function instead and using CROSS APPLY in the query.

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

Your options are: Derived table/inline view (like you used in your example) Common Table Expression (CTE), which is just alternate syntax for a derived table/inline view Table Valued Function (TVF) ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.