Using SP in query clause. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using SP in query clause.

I used function in the query clause. I wander if anybody used stored procedure as part of the query clause. Thanks,
Davis

you can’t use a stored procedure as part of a query clause… the only exception is insert into…exec Cheers
Twan
That is what we concluded from our tests. Thanks for confirming. Davis

]]>