这个看起来似乎比较难.
查询的结果是
GroupName Price
-------------------------------------------------- ---------------------
VIP客户 1011.00
白金卡会员 225.00
(2 行受影响)
要转成
VIP客户 白金卡会员
1011.00 225.00
有没有人指导下.不胜感激!
------解决方案--------------------
- SQL code
CREATE TABLE tb (GroupName VARCHAR(64),Price decimal(10,2))INSERT INTO tbSELECT 'VIP客户',1011.00 UNION ALLSELECT'白金卡会员',225.00UNION ALLSELECT'白金卡会员1',225.00UNION ALLSELECT'白金卡会员2',225.00UNION ALLSELECT'白金卡会员3',225.00UNION ALLSELECT'白金卡会员4',225.00UNION ALLSELECT'白金卡会员4',225.00--DROP TABLE tbdeclare @s nvarchar(max)set @s=''Select @[email protected]+','+quotename(GroupName)+'=max(case when [GroupName]='+quotename(GroupName,'''')+' then [price] else 0 end)'from tb group by GroupNameSELECT @s=SUBSTRING(@s,2,LEN(@s))EXEC ('select [email protected]+' from tb ')/*VIP客户 白金卡会员 白金卡会员1 白金卡会员2 白金卡会员3 白金卡会员4--------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ---------------------------------------1011.00 225.00 225.00 225.00 225.00 225.00(1 行受影响)*/