|Programming in MS SQL Server 2012|
Multi Table-valued Function
In-line table functions returns a single table variable that was created by a SELECT statement. Multi-statement table functions returns a table variable whose structure was created by code, similar to a CREATE TABLE statement. It is useful when complex data manipulation inside the function is required.
The following example describes a Multi Table-valued function concept.
Query Output Screen
* * * * *