In case you have not come across table valued functions before, you can call them like a normal table.
Here is an example:
You can also join to table valued functions but must use CROSS APPLY and OUTER APPLY instead of INNER JOIN and LEFT JOIN.
This example shows how it works when cross applied:
Cross apply is required as the values passed into the function are not available using an INNER JOIN.
Aside from this CROSS APPLY and INNER JOIN are more or less identical and the query optimiser may switch an INNER JOIN to a CROSS APPLY anyway.
The list of table valued functions used by Guildford College Reports and any anyone else wishes to share
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests