Hello, I am trying to work out why when I query a table why I get a different result than what is contained in the attribute table? Field I'm interested in is RCODE_NO, ID is unique, and the SQL query is a simple one:
SELECT PIN, ID, RCODE_NO FROM ArcSDE.GISDBA.City_TPS24New WHERE PIN=123998
What I find extremely strange about this is I copied the table into a new Enterprise Geodatabase in Catalog and it seems to work as expected?
Any help would be greatly helpful, SQL novice here 😅
1. Done
2. Microsoft SQL Server 2017 14.0.3451.2 (Build 14393: )
3. Enterprise 10.8.1
4. ArcPro 3.2.2
5. Upon closer inspection, no the field is not unique and yes there are nulls.
6. The RCODE_NO value in the query layer should be "R60"
7. See below (cannot get query layer field views as the option is greyed out):
Is the data versioned?
Yes, traditionally versioned.
My experience is that most query layer problems stem from the unique ID field. Hopefully, if you clean up that field, your issues will go away.
Will give that a crack, cheers!
I would also ask if the data is versioned?
Yes, the feature datasets are both versioned (traditional).