Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How do i use a SP. in subquery?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-14 : 06:59:32
Maheswaran writes "Very arrgent:


how do i use a existing storedprocedure in subquery?"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-07-14 : 09:21:38
One easiest way is to use the query used in SP in your subquery

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-07-14 : 09:29:21
if it's a complex sproc you can't.
one option is to rewrite it as a function.

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -