在SEDE中查询评论ID (存储在表中)的不同值的评论员存储库和发布者存储库

Question

如何修改以下查询

SELECT
  CASE WHEN U.Id = P.OwnerUserId THEN 'Poster' ELSE 'Commenter' END AS [User],
  U.Id AS [User Link],
  U.Reputation AS [User Rep]
FROM Comments AS C
INNER JOIN Posts AS P
  ON P.Id = C.PostId
INNER JOIN Users AS U
  ON U.Id IN (P.OwnerUserId, C.UserId)
WHERE C.Id = ##CommentId:int##

这样CommentId :就是表中的每一行，只包含注释ID的常量值。具体来说，我想为表的每一行迭代这个查询：

       Comment ID <-- Table 
        3421105
        1041243
        8118167
        3073399
        712153
        1877813
        834036
        6233902
        7762628
        7944447
        724240
        3256044
        3041609
        6206686
        7825212
        6143469
        5818437
        5209319
        4358493
        7697908
        2157522

以下是可以运行查询的链接：

https://data.stackexchange.com/stackoverflow/query/180387/name-and-rep-of-commenter-and-op-for-comment-id#resultSets

我是SQL查询的新手，如果版主或高声誉的用户觉得这是一个微不足道的问题，如果你能指导我提出类似的问题，我将非常感激。

输出结果应如下所示：

  COMMENTOR REPO |  POSTER REPO  |   COMMENT ID

    ..                 ..              ..
    ..                 ..              ..

Answer 1

DECLARE @T TABLE(Id int PRIMARY KEY);

INSERT INTO @T VALUES 
(3421105), (1041243), (8118167), (3073399), (712153 ), (1877813), (834036 ), 
(6233902), (7762628), (7944447), (724240 ), (3256044), (3041609), (6206686), 
(7825212), (6143469), (5818437), (5209319), (4358493), (7697908), (2157522)

SELECT
  CU.Reputation AS [COMMENTER REPO],
  PU.Reputation AS [POSTER REPO],
  C.Id AS [COMMENT ID]
FROM Comments AS C
  INNER JOIN Posts AS P
    ON P.Id = C.PostId
  INNER JOIN Users AS PU
    ON PU.Id = P.OwnerUserId
  INNER JOIN Users AS CU
    ON CU.Id = C.UserId
WHERE C.Id IN (SELECT T.Id FROM @T AS T)

Data exchange