How to calculate 3d intersection using SQL Query

[BattulgaGantulga]

Hi, I try to Intersect 3d polygon and Lines on SQL Server. But it's not working. Please support me on this issue. How to correct dynamically calculate intersection of 3D Line and Polygon?

I wrote following SQL Query.

SELECT 
    P.*,
    L.Shape.STIntersection(P.Shape).ToString() AS IntersectionPoint,
    L.Shape.STIntersection(P.Shape).STLength() AS IntersectionLength
FROM 
    (
        SELECT 
            geometry::UnionAggregate(Shape) AS Shape
        FROM 
            Geol_LicenseBoundary3DA
        WHERE 
            Layer LIKE 'LB_XXX%' AND last_edited_date IS NULL
    ) AS P
JOIN 
    (
        SELECT  
            geometry::UnionAggregate(Shape) AS Shape
        FROM 
            Geol_DH_ActualTraceL 
        WHERE 
            HOLEID = 'UGDXXX'
    ) AS L 
ON 
    P.Shape.STIntersects(L.Shape) = 1;

Thanks

[JesseCloutier]

Thanks for bringing your question to Esri Community, @BattulgaGantulga.

Which ArcGIS product are you using? I'd like to help get this post moved to a more relevant Board where it's more likely to be seen and responded to by members with relevant expertise.

[BattulgaGantulga]

Hi Jesse Cloutier,

   Our Database is SDE Spatial Database on MS SQL Server. We are using ArcGIS Products (ArcGIS Enterprise, ArcGIS Pro)

Thanks 

[JesseCloutier]

Thanks for following up, @BattulgaGantulga. I've moved your post to our ArcGIS Pro Questions Board. All the best!