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 Nov 6, 2019 by gayle.horner_neufel_adfg2

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?