use SQL server is much better than use Arcgis Pro.


Here is example: 

I want to know how many unique fire unit code and what they are. I want to compare old unit code with current unit code to see what unit code missing from 2 different layers. 




To use ArcPro (Left side):

You can use select by attribute tool, new selection, where unite code is equal to, the drop down list shows all possible unique unit code. 





To use SQL server query ( right side ):

Use disticnt or group by key word to run sql query. 



SQL query is much better, I can copy result to excel, then send to COTS(commercial off the shell) application vender, firstWatch



 I can run 2 sql query to compare old table with current table to see what unit code is missing. Also send to COTS(commercial off the shell) application vender, firstWatch.  





In ArcPro, I just can do none of them. 







Please log in or register