I have a table valued UDF (it returns a number of rows). How can I aggregate the table valued results in a SQL query?
I'd like to do something like
select GetMyTableValuedResults开发者_运维百科(MyColumn1)
from MyTable
But this TSQL doesn't compile...
Thanks.
SELECT res.*
FROM MyTable
CROSS APPLY dbo.GetMyTableValuedResults(MyColumn1) res
精彩评论