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 Rhinorhino 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
Joined
Sep 18, 2002
Messages
3
Location
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 Question
Field change as caused issues to store procedure
Replies
19
Views
1K
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
272
Auguy
Auguy
BeatriceC
  • Locked
  • Question Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
385
pjw001
pjw001
ghiehotamares
  • Locked
  • Question Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
353
fredericofonseca
fredericofonseca
BTrees
  • Locked
  • Question Question
Run Procedure Against Link Server (from local server , populate data in local server)
Replies
1
Views
265
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top