14 Replies Latest reply: Apr 30, 2014 7:32 AM by Toni Kautto RSS

    ms sql select incorrect data

      hi at all,

       

      i've a problem: i made a qv file that read data from a sql server 2011r2. i have an odbc connection that function correctly with other programs (for example with ms Access and Toad).  i create a select statement on a table with 90000 rows that return some rows with the char key filed incorrect.

       

      ON DB TABLE

      KEY - DESCRIPTIO

      078000 - AAAA

      078E01 - BBB

      078F05 - CCC

       

      ON QV TABLE

      KEY - DESCRIPTION

      078000 - AAAA

      078000 - BBB

      078000 - CCC

       

      if i insert a where condition with explicit reference of a description the result is correct.

       

      for example:

      select key,description from table where description like '%BBB%'

      ON QV TABLE I OBTAIN

      KEY - DESCRIPTION

      078E01 - BBB

       

      i test qlikview release 10 and the problem persist.

       

      Can anyone help me?