Find Polygon Overlaps

I have to find polygon overlaps and get their geometry. Does anybody have idea how to do that? This is polygon table: DECLARE @Table TABLE ( id varchar(32), shape geometry); I

Solution 1:

Would this work?

SELECT
    T.id
    , O.id
    , T.shape.STIntersection(O.shape) Intersection
FROM @Table T
INNER JOIN @Table O
    ON T.shape.STIntersects(T.shape) = 1
    AND T.id > O.id