开发者

Aggregate result of table valued UDF

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜