Our corporate GIS is being upgraded and certain SQL queries need to be simplified to work. We can’t call stored procedures/run dynamic queries or create temporary tables in these queries once we upgrade. The below query creates a pivot table using a dynamic query and I cannot figure out a workaround. It outputs the number of common species within certain cells.