1. psmoreno New Member

   
   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 statements2727
   
   
   -- result with storage procedure
   Rows effected by SELECT statements5454
   
   Appreciate yours comments

   psmoreno, Aug 27, 2005

   #2
2. Luis Martin Moderator

   Could you post your sp?.
   
   Luis Martin
   Moderator
   SQL-Server-Performance.com
   
   One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
   Bertrand Russell
   
   
   All postings are provided “AS IS” with no warranties for accuracy.
   
   
   
   

   Luis Martin, Aug 27, 2005

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in