Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Executing store procedure

Status
Not open for further replies.
Anfel

Anfel

Programmer
Sep 18, 2002
3
0
0
US
Is it possible to execute or call store procedure in the criteria part of selet statement of another store procedure?

Thanks in advance
 
Sort by date Sort by votes
I don't think you can... But you could execute the SP and store the returned value in a variable. Then use the variable in your select criteria...

Hope that helps..
mwa
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
99
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
43
Auguy
Auguy
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
44
pjw001
pjw001
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
43
fredericofonseca
fredericofonseca
BTrees
  • Locked
  • Question
Run Procedure Against Link Server (from local server , populate data in local server)
Replies
1
Views
31
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top