SQL Server Pivot创建所有NULL值

发布于 2025-02-12 06:33:08 字数 1997 浏览 2 评论 0原文

我有以下数据要枢转。我的目标是每个标签的一排，每个星期成为一列，该列是一周的价值。

标签	周率	51220
51220	周0	-11
51220	周1	-41
51220	周2	159
51220	周	周3 117
51220	4	207
51220	周5	-37
周6 138 51220	8	-42
51220	周7 139 51220周	-45 51220周9 -45 51220周9 -45
周	8	-42
51220	周9	51220周9 -45 51220周9 -45
9 -45 51220	51220周 10	-82
51220	周11	-85
51220	周12	-25
51347	周023	51347
51347	周1	24
51347	周2	51347
周	25	51347
周	25	51347
周	24	51347
周	24	24
周	6	24
51347	7	24
51347	周	7
51347	周	4
25	周	5
3	6 12	23

在这里我的查询：

SELECT * FROM table1
PIVOT (
SUM(Rate) FOR Week IN (Week0,Week1,Week2,Week3,Week4,Week5,Week6,Week7,Week8,Week9,Week10,Week11,Week12)
) pivot_table;

这个结果始终为无效。我在做什么错误？我正在关注几个教程，但没有成功。

原文

I have the following data I am trying to pivot. My goal is one row for each Label, and each week becomes a column with the rate as the week's value.

Label	Week	Rate
51220	Week 0	-11
51220	Week 1	-41
51220	Week 2	159
51220	Week 3	117
51220	Week 4	207
51220	Week 5	-37
51220	Week 6	138
51220	Week 7	139
51220	Week 8	-42
51220	Week 9	-45
51220	Week 10	-82
51220	Week 11	-85
51220	Week 12	-25
51347	Week 0	23
51347	Week 1	24
51347	Week 2	25
51347	Week 3	25
51347	Week 4	25
51347	Week 5	24
51347	Week 6	24
51347	Week 7	24
51347	Week 8	24
51347	Week 9	24
51347	Week 10	24
51347	Week 11	24
51347	Week 12	23

Here my my query:

SELECT * FROM table1
PIVOT (
SUM(Rate) FOR Week IN (Week0,Week1,Week2,Week3,Week4,Week5,Week6,Week7,Week8,Week9,Week10,Week11,Week12)
) pivot_table;

This results are always NULL. What am I doing incorrectly? I'm following several tutorials with no success.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

慕烟庭风 2025-02-19 06:33:10

是的，那些支架会这样做。


SELECT * 
FROM (VALUES('51220','Week 0',-11)
,('51220','Week 1',-41)
,('51347','Week 1', 24)
) table1(Label, Week, Rate)
PIVOT (SUM(rate) FOR WEEK IN ([Week 0],[Week 1])) AS pivot_table

Yeah, those brackets will do it.


SELECT * 
FROM (VALUES('51220','Week 0',-11)
,('51220','Week 1',-41)
,('51347','Week 1', 24)
) table1(Label, Week, Rate)
PIVOT (SUM(rate) FOR WEEK IN ([Week 0],[Week 1])) AS pivot_table

回复收藏 0 原文

~没有更多了~