SqlServer遞迴查詢

DECLARE @ParentId NVARCHAR(36);
SET @ParentId = `078499bf-dedd-b293-4653-7bf6a2e54cbb`;

WITH [Temp] AS
(
    SELECT [A].* FROM [dbo].[Contacts] A WHERE [A].[ParentID] = @ParentId AND [A].[IsDefault] = 1
    UNION ALL
    SELECT [A].* FROM [dbo].[Contacts] A INNER JOIN [Temp] B ON A.[ParentID] = B.[ObjectID] AND [A].[IsDefault] = 1
)
SELECT * FROM [Temp] ORDER BY [Temp].[GlobalSort] ASC;