5 Replies Latest reply on Oct 21, 2014 1:43 PM by episking

    ODBC, non-unique values (MSSQL 2008 R2)

    episking

      Title

      ODBC, non-unique values (MSSQL 2008 R2)

      Post

      I have an ODBC connector set up and working properly with several views.  This particular view is giving me troubles, saying "the selected columns contain some non-unique identifiers..."  See the below screenshots:

       

       

      Here's some sample data from the text field "ProjectNumber".

      14-03384
      14-03417
      14-03446
      14-03461
      13-02477/001
      13-02477/011
      12-02189/001
      12-02152/001

       

      I have run SQL queries to find non-unique, and it comes up with none, so I am confident that there are no non-unique entries in the ProjectNumber column.

       

      Help!

      -EP