开发者

Aggregate result of table valued UDF

开发者 https://www.devze.com 2023-03-07 06:16 出处:网络
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 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
0

精彩评论

暂无评论...
验证码 换一张
取 消