Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    99

    Unanswered: Different results same query between original and copied db

    Hi all,

    I restored a backup of a database running SQL Server in W2K to my own laptop (Windows XP) for report testing pourposes. The restore worked perfectly, but when I ran the store procedure that returns my "report" set I noticed that several of the fields within the result set are different, the number of rows and customers are a perfect match to the production report. The fields that are different are calculated fields that invoque a user defined function, which again are exactly the same on both databases. I tried dropping the stored procedure and the 4 functions and recreating them again but I get the same results, the number of rows, the customers and all "non" function calculated fields are perfect, only the fields calculated with the functions are wrong.

    Has anybody seen this behavior?

    Thanks for your help

    Luis Torres

  2. #2
    Join Date
    Jun 2005
    Posts
    50
    do u have Nondeterministic Functions like rand() ..??

  3. #3
    Join Date
    Aug 2004
    Posts
    99
    nope, but I solved the problem, I didnt have the service pack 3 installed on my laptop and after installing it everything worked perfect.

    Thanks for your help

    Luis Torres

  4. #4
    Join Date
    Jun 2005
    Posts
    50
    would like to know wat SP3 did !!!

  5. #5
    Join Date
    Aug 2004
    Posts
    99
    Yeah, I would love to, I like the solution better when I understand the problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •