Hi, I have a stored procedure that requires several input parameters. I
would like to join the results of the stored procedure with another
table but I'm having a tough time getting the syntax correct. For
example:
To run the stored procedure:
exec usp_FetchPeople(@Gender = 'F', @City = 'Boston')
This returns a table:
PID | Age | Email
Now I want to join this with a table of notes but I can't get the syntax
corret. Something like this:
select N.Note from Notes as N
inner join (exec usp_FetchPeople(@Gender = 'F',
@City = 'Boston')) as P on P.PID = N.PID
but I get errors. What is the correct syntax? Thank you very much.
David
<img src="http://www.sen.us/mirror/SENLogo_62_31.jpg">
Meet people for friendship, contacts,
or romance using free instant messaging software! See a picture you
like? Click once for a private conversation with that person!
http://www.sen.us
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!