storage procedure x select

• Paulo S Moreno

  Newbie

  Points: 1

  More actions

  August 27, 2005 at 8:54 am

  #168425

  Curious

  If I execute the same select, out storage procedure, the result in the Statistics is double rows number. Why ???

  -- result with select direct

  Rows effected by SELECT statements 27 27

  -- result with storage procedure

  Rows effected by SELECT statements 54 54

  Appreciate yours comments

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 27, 2005 at 9:11 am

  #585674

  could you pl. post the select statement that you're using ?!?! thx!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**