regarding stored procedure looping

• nicole1981

  Newbie

  Points: 3

  More actions

  July 5, 2003 at 7:23 am

  #175978

  hi, i have some problems with my stored procedure. i have 3 stored procedures, SP1, SP2, SP3. in SP1, i have a cursor that first exec SP2 (SP2 will output variable var1), after which var1 will be passed into SP2 as paprameter.

  in SP2, var1 is used for calculation to get var2, e.g. var2=var1*1000, after which var2 is inserted as a new row, together with some other values, into table T1. but when i checked T1, it seemed like var2 does not change, maeaning that var1 entered into table is always the same value. anyonw has any suggestions as to where i may go wrong?

  thanks

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 5, 2003 at 3:51 pm

  #464221

  Hard to tell without you posting the actual code. Where does SP3 come into play?

  Have you tried a series of PRINT, SELECT or RAISERROR...NOWAIT statements to track values of variables during execution?

  
  Cheers,
  - Mark