• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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
0
quigleyryan
Asked:
quigleyryan
1 Solution
 
chapmandewCommented:
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

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now