AnsweredAssumed Answered

How can I interact with a Function Statement in SQL Server in ArcGIS?

Question asked by jacquealope on Aug 21, 2017
Latest reply on Aug 29, 2017 by jacquealope

I previously have only used Views to do complex queries but recently one of our database guys made me a couple of functions instead because he is pulling data from multiple databases and doing some complex things.  These are not showing up in the table list like a view does so I can't plot the XY manually in ArcMap.  To remedy this, he made a View out of the Function but in SQL Server Management Studio it takes 12 seconds to select the top 1000 records and in ArcGIS it never loads.

 

Is there a way to interact with SQL Function Statements in ArcGIS?

Outcomes