passing parameter to stored procedure

have a stored procedure that parse a string and sends back an appropriate formatted string.
the stored procedure works - but this stored procedure is called from other stored procedures and i'm having an issue with syntex
set @value = dob.mystoredprocedure @value
gives a syntex error
if i try set @value = exec dob.mystoredprocedure @value
it doesn't like the exec or the last @value
help
quigleyryanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chapmandewConnect With a Mentor Commented:
are you using an output parameter, or the return param(which has to be an INT)


if output:
declare @value varchar(50)
exec dob.mystoredprocedure @value output

select @value
0
 
R_JanssenCommented:
use SELECT....
SELECT @Bla = MyStoredProcOrFunctionOrQuery.
 
0
 
quigleyryanAuthor Commented:
thanks - that's perfect
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.