Post reply

there is something strange?!?!?!?Please help me!!!

  • February 10, 2004 at 2:58 am

    #160739

    I got 2 DB (identical) on the same server.

    I gat the same query, if i run the quey on the first da the result seem to be true but in the ither one it looks to be false!!!

    Why!!

    This is the query!!

     SELECT DISTINCT

      TMP1.MATNR , 1

     FROM #TMP_PROD TMP1

     WHERE NOT EXISTS (SELECT * FROM  #TMP_COMP TMP2 ,

            #TMP_PROD TMP3

             WHERE TMP2.AUFNR = TMP1.AUFNR and

            TMP3.MATNR = TMP2.COMPNR)

    In my opinion the problem is in the NOT EXIXT Clause!!!

    Is there any setting or some other thing that can make it!!

    Thanks Alessandro

  • February 10, 2004 at 8:34 am

    #493399

    I would try to get the contents of the temporary tables being used.  My guess would be that they do not hold the same information in both databases at this point of the process.

    Guarddata-

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply