如何在T-SQL中形成站点之间的距离矩阵？

-- 创建站点表格
CREATE TABLE Sites (
    SiteID INT PRIMARY KEY,
    SiteName VARCHAR(50),
    Location GEOGRAPHY
);

-- 插入示例数据
INSERT INTO Sites (SiteID, SiteName, Location)
VALUES
    (1, 'Site A', geography::Point(40.7128, -74.0060, 4326)),
    (2, 'Site B', geography::Point(34.0522, -118.2437, 4326)),
    (3, 'Site C', geography::Point(51.5074, -0.1278, 4326));

-- 创建距离矩阵表格
CREATE TABLE DistanceMatrix (
    SiteID1 INT,
    SiteID2 INT,
    Distance FLOAT
);

-- 计算距离矩阵
INSERT INTO DistanceMatrix (SiteID1, SiteID2, Distance)
SELECT
    s1.SiteID,
    s2.SiteID,
    s1.Location.STDistance(s2.Location) AS Distance
FROM
    Sites s1
CROSS JOIN
    Sites s2;

-- 查询距离矩阵
SELECT * FROM DistanceMatrix;