1 comment

Add a comment…

Sign in

prestine

Your email address

Check!

invalid email

(thinking…)

Reset

or sign in with

• 
• 

UserVoice password

Forgot password?

Create a password

Your name

I agree to the terms of service

You'll receive a confirmation email with a link to create a password (optional).

Signed in as (Sign out)

Close

Close

Post comment Submitting...

• Adminmobile[foo] (MobileFoo, MobileFoo) commented  ·  November 16, 2011 02:41  ·  Flag as inappropriate  ·  Delete

  Assuming your stored procedure already has an appropriate output parameter, you can then just SELECT that after executing it, for example:

  DECLARE @someParam varchar(100)
  EXEC myProcedure, @myProcOutputParam=@someParam OUTPUT
  SELECT @someParam

  You can then retrieve the result of the select statement as normal. (Though it may not be the first resultSet, if I remember correctly - you might have to skip over an empty one first.

  Thanks,
  Rob
  mobile[foo]