I am working with MS SQL Server 2012 and ArcMap 10.4.
I'm a bit of newbie to SQL so please bear with me.
I have created a view in my database using the following query:
CREATE VIEW dbo.intermediate
SELECT MIN(pa.OBJECTID) OBJECTID, MIN(pa.INT_NAME) INT_NAME,
MIN(pa.INT_NAME) + ' INT' AS CAMPUS, MIN(pa.ISD) ISD,
FROM dbo.pa_evw as pa
GROUP BY pa.ISD, pa.INT_NAME
Where 'dbo.pa_evw' is an archived view of a polygon layer with a category field called INT_NAME.
The query runs without an error in SQL Server Management Studio and the spatial results look how I would expect them to. However, when I bring the layer into ArcMap, I get a drawing error that says there is a "Shape integrity error."
Can anyone point me in the right direction?