sql - SQL Server CTE 递归次数过多

Question

我需要一些帮助来确定构建此查询的最佳方法，并且我认为我已经决定 CTE 是最好的主意。如果可能有更好的方法，我愿意接受其他建议。

此应用程序有几种不同的对象类型。我目前关注的对象的简单层次结构如下Group -> Catalog(s) -> Item(s) and Feature(s) -> Features (items also connect to features) -> Feature Values：这些对象中的每一个也都是版本化的，因此它们可能是第一个版本，也可能是多个版本。（这个层次结构只是为了理解试图完成的事情。

我要处理的数据都包含在一个History表中。该表具有以下列：HistoryID, HistoryObjectID, HistoryObjectCode, HistoryObjectTypeID, HistoryMessage, HistoryObjectTypeObjectID, Timestamp, ParentHistoryID, ParentObjectID, HistoryObjectGuid, NetworkID

• HistoryObjectID 是一个 ID，它外键到创建行的对象表（如 Group、Catalog 等）
• HistoryObjectCode 是对象表中的另一个标识符，在 UI 中使用
• HistoryObjectTypeID 是一个枚举，对应于 Object 的类型（即 Group、Catalog 等）
• 消息应该是不言自明的
• HistoryObjectTypeObjectID（坏名）是对象的主键
• 时间戳 - 不言自明
• ParentHistoryID - 如果这个历史记录是从另一个“产生”的，则填充。我们现在实际上并没有真正使用它。
• ParentObjectID - 这是 CTE 中使用的当前列。这是用对象的“父”的主键填充的。这被定义为对象的父版本的主键（如果有的话）。如果这个版本是第一个版本，那么它就是父对象的主键。因此，对于目录的第一个版本，它填充了包含目录的组 ID。

这是我目前的查询。我的问题是递归发生在“基本情况”中返回的每一行：

WITH n(HistoryID, HistoryObjectID, HistoryObjectTypeID, HistoryObjectTypeObjectID, HistoryObjectCode, HistoryMessage, UserID, Timestamp, ParentHistoryID, ParentObjectID, HistoryObjectGuid) AS (
    SELECT HistoryID, HistoryObjectID, HistoryObjectTypeID, HistoryObjectTypeObjectID, HistoryObjectCode, HistoryMessage, UserID, Timestamp, ParentHistoryID, ParentObjectID, HistoryObjectGuid 
    FROM [DBName].[History] 
    WHERE HistoryObjectID = @HistoryObjectID
  UNION ALL 
    SELECT nplus1.HistoryID, nplus1.HistoryObjectID, nplus1.HistoryObjectTypeID, nplus1.HistoryObjectTypeObjectID, nplus1.HistoryObjectCode, nplus1.HistoryMessage, nplus1.UserID, nplus1.Timestamp, nplus1.ParentHistoryID, nplus1.ParentObjectID, nplus1.HistoryObjectGuid
    FROM [DBName].History as nplus1
    INNER JOIN n on n.HistoryObjectTypeObjectID = nplus1.ParentObjectID) 
  SELECT n.HistoryID, n.HistoryObjectID, n.HistoryObjectCode, n.HistoryObjectTypeID, n.HistoryMessage, n.HistoryObjectTypeObjectID, n.Timestamp, n.ParentHistoryID, n.ParentObjectID, n.HistoryObjectGuid, u.NetworkID
  FROM n INNER JOIN [CatalogBuilder].[User] u on n.UserId = u.UserId

例如，具有特定 ID 的以下查询运行之一导致返回 1653 行，在基本情况下返回 28 行。如果我distinct在最后的 select 语句中添加 a，我只会得到我真正感兴趣的 49 行。明显的问题是由于不必要的递归，这个查询需要很长时间才能运行。

我愿意接受有关如何做到这一点的任何建议，这是一种更好的方法。

编辑：添加示例数据

期望的结果（返回 14 行）：

+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+
| HistoryID | HistoryObjectID |   HistoryObjectCode   | HistoryObjectTypeID |                   HistoryMessage                   | HistoryObjectTypeObjectID |          Timestamp          | ParentHistoryID | ParentObjectID |          HistoryObjectGuid           |       NetworkID        |
+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+
|    313404 |          572668 | TEST CATALOG CREATION |                   3 | Created catalog version 1.0.0 for catalog TESTCAT  |                       201 | 2019-01-04 15:02:22.1533333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319335 |          572668 | CATALOGCODE           |                   3 | Updated Catalog code to CATALOGCODE                |                       201 | 2019-01-23 21:29:19.6933333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319538 |          572668 | CATALOGCODE           |                   3 | Set English description to "new desc edited"       |                       201 | 2019-02-04 18:32:11.2166667 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319539 |          572668 | CATALOGCODE           |                   3 | Added ADP to Catalog                               |                       201 | 2019-02-04 18:32:14.3100000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319544 |          572668 | CATALOGCODE           |                   3 | Added USD to Catalog                               |                       201 | 2019-02-05 13:36:11.5433333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319551 |          572668 | CATALOGCODE           |                   3 | Added CAD to Catalog                               |                       201 | 2019-02-06 14:35:28.9100000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319552 |          572668 | CATALOGCODE           |                   3 | Added USD to Catalog                               |                       201 | 2019-02-06 14:35:28.9700000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+

返回的行数过多（56 行）：

+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+
| HistoryID | HistoryObjectID |   HistoryObjectCode   | HistoryObjectTypeID |                   HistoryMessage                   | HistoryObjectTypeObjectID |          Timestamp          | ParentHistoryID | ParentObjectID |          HistoryObjectGuid           |       NetworkID        |
+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+
|    313404 |          572668 | TEST CATALOG CREATION |                   3 | Created catalog version 1.0.0 for catalog TESTCAT  |                       201 | 2019-01-04 15:02:22.1533333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319335 |          572668 | CATALOGCODE           |                   3 | Updated Catalog code to CATALOGCODE                |                       201 | 2019-01-23 21:29:19.6933333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319538 |          572668 | CATALOGCODE           |                   3 | Set English description to "new desc edited"       |                       201 | 2019-02-04 18:32:11.2166667 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319539 |          572668 | CATALOGCODE           |                   3 | Added ADP to Catalog                               |                       201 | 2019-02-04 18:32:14.3100000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319544 |          572668 | CATALOGCODE           |                   3 | Added USD to Catalog                               |                       201 | 2019-02-05 13:36:11.5433333 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319551 |          572668 | CATALOGCODE           |                   3 | Added CAD to Catalog                               |                       201 | 2019-02-06 14:35:28.9100000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319552 |          572668 | CATALOGCODE           |                   3 | Added USD to Catalog                               |                       201 | 2019-02-06 14:35:28.9700000 | NULL            | NULL           | 3CE6BD8D-3AF4-46D2-9004-976113E110CD | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319685 |          585464 | TESTITEM8             |                   4 | Created Item TESTITEM8 - 1.0                       |                     52051 | 2019-02-11 15:32:49.8633333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319686 |          585464 | TESTITEM8             |                   4 | Set English name to "Test item #8"                 |                     52051 | 2019-02-11 15:32:54.0033333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319687 |          585464 | TESTITEM8             |                   4 | Created item version 1.0                           |                     52051 | 2019-02-11 15:32:56.8800000 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319688 |          585464 | TESTITEM8             |                   4 | Set English description to "Test Item Description" |                     52051 | 2019-02-11 15:33:00.4266667 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319689 |          585465 | NEW-FEATURE-CREATION  |                   6 | Set English name to "test"                         |                     19224 | 2019-02-11 16:27:33.6400000 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319690 |          585465 | NEW-FEATURE-CREATION  |                   6 | Created feature version 1.0                        |                     19224 | 2019-02-11 16:27:33.9066667 | NULL            | 201            | 55ACDB43-51E6-4A5D-94DB-8B0808F946D6 | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
|    319692 |          585464 | TESTITEM8             |                   4 | Linked feature NEW-FEATURE to item                 |                     52051 | 2019-02-11 18:59:17.2133333 | NULL            | 201            | FB3D799F-2038-4CE1-A27E-0C6F6EBE607F | [e-mail] |
+-----------+-----------------+-----------------------+---------------------+----------------------------------------------------+---------------------------+-----------------------------+-----------------+----------------+--------------------------------------+------------------------+

似乎每次运行基本案例都会返回“额外”行。在基本情况下返回 7 行，其他 7 个条目中返回 49 行，这应该是唯一的，并且是所需的结尾 14 行的来源（基本情况中的 7 行 + 其他 7 个唯一行）。

标签： sqlsql-servertsqlcommon-table-expression