AnsweredAssumed Answered

ODBC, non-unique values (MSSQL 2008 R2)

Question asked by episking on Oct 20, 2014
Latest reply on Oct 21, 2014 by 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

Outcomes