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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure with SELECT Query

Status
Not open for further replies.
noodles1

noodles1

Programmer
Oct 31, 2001
58
Whilst, I know it is pssible to execute a Stored Prcoedure within a SELECT query, can I call a Stored Procedure where one or more of the arguments that need to be passed are obtained through a JOIN within the SELECT query?
 
Sort by date Sort by votes
Oops,
Again I forgot about OPENROWSET()

Check thread183-1304025, especially Denis' answer to me.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
564
Chriss Miller
C
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
949
Andrzejek
Andrzejek
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
955
SashaBuilder3
SashaBuilder3
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
624
grnzbra
grnzbra
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top