SQL Server 2016 Spatial table data: Combine duplicate polygons into one

Question

I have a spatial table that I imported from ArcGIS file geodatabase into SQL Server. In the table, there are hundreds of duplicate rows having the same ID that I need to "merge"/combine into a single row (which would result in combining two polygons into one for each polygon having the same ID--usually two).

Does anyone know how this can be done? I can manually merge them using ArcGIS Pro but there are thousands of these rows that it's impossible to complete this task in due time.

Appreciate any help.

Answer 1

It seems like there's nobody to answer my question. So I went back to ArcGIS Pro. I used the tool, "Dissolve" (I forgot about this tool). I specified the dissolved field as the ID of the feature. The tool then dissolves all features into one if the value of the ID is the same.

This in effect got rid of the duplicate data. I can then export the resulting feature class or table into SQL Server for further queries using other tables I need.