Question

This question already has answers here:

Possible Duplicate:
Concatenate a selected column in a single query?

我知道这一点在我的SQL中相当简单,但我不知道如何在Server这样做。我的表格有两栏。用户ID & TagID。我愿将TagID压缩为 com马分道,结果由用户信息数据库分类。如何做到这一点?

Answer 1

我想想一下一下一下一下你在寻求的东西:

SELECT   +Table1.UserID+ , +Table2.TagID+   AS CombinedCSVColumn
      , SUM(Table1.Value) AS Value
From dbo.Table1 as Table1
INNER JOIN db.Table2 as Table2
ON Table1.EmployeeID = Table2.EmployeeID
GROUP BY   +Table1.UserID+ , +Table2.TagID+

也就是说,如果来自两个表。一个表格类似。

关于

澳门

友情链接