Using columns from a procedure

• sqlservercentral@onskee.com

  SSC Veteran

  Points: 232

  More actions

  January 31, 2003 at 12:10 pm

  #357696

  Hi everyone,

  I'm wondering if there's a way that I can address different columns that a stored procedure returns. I know that I'm not explaining this properly, but in ASP code, I can execute a stored procedure and then use the columns in my code:

  myField = RS("ColumnName")

  So I want to execute that stored procedure which does not have output parameters, only returns a recordset. Then assign variables to the columns in the stored procedure.

  Something to the effect of:

  Declare @var1 varchar(20), @var2 varchar(20)

  exec MyStoredProc

  Set @var1 = (** one of the columns from that proc **)

  Set @var1 = (** another one of the columns from that proc **)

  Does this make a lick of sense??

  Thanks

• February 3, 2003 at 8:00 am

  This was removed by the editor as SPAM