Help

• aysegul

  Right there with Babe

  Points: 778

  More actions

  August 27, 2007 at 12:42 am

  #98489

  Hi All,

  I want to make an storedprocedure.

  I'll call some storedprocedure in this new storedprocedure.But,I don't know that How I can take the output field's value of the storedprocedure which I call from the new storedprocedure.

  I mean;

   

  EXEC @rc = [DANCA].[dbo].[sel_genelsatisfiyat3] @urunid, @ekurun, @firmid, @fiyatkategorisi, @orderdate, @bfiyat3 OUTPUT , @pbrm3 OUTPUT

  How can I take the value of @bfiyat3 or @pbrm3 and use it in my new stored procedure?

  Thank you very much.

  Kind regards..

  Aysegul

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 27, 2007 at 2:52 am

  #729492

  Create table #temp (<many column definitions here&gt

  insert #temp

  exec DANCA].[dbo].[sel_genelsatisfiyat3] @urunid, @ekurun, @firmid, @fiyatkategorisi, @orderdate, @bfiyat3 OUTPUT , @pbrm3 OUTPUT

  Or write stored procedure as FUNCTION if all the SP do is to retreive records.

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  August 27, 2007 at 8:21 am

  #729549

  Peter has a great suggestion.