How to assign result set from a stored procedure to a variable ?

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  January 24, 2011 at 11:47 am

  #232621

  I have a dynamic code which returns single row single column result set. I want to pass it to a variable. I am using sp_executesql for dynamic execution. Is it possible ?

  Thanks

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  January 24, 2011 at 1:08 pm

  #1277437

  You can define an output parameter using sp_executesql which might work for you.

  Check it out in BOL: http://msdn.microsoft.com/en-us/library/ms188001.aspx

  _____________________________________________________________________
  - Nate

  @nate_hughes