MS SQL 行转列的有关问题

MS SQL 行转列的问题
联合查询后得到如下下表：


Fbillno Finterid Fstatus Fitemid Fauxqty Fdate Fqty
 
WORK0055256595 3 28086 100.00000000002012-05 100.0000000000
WORK0055266602 3 28090 300.00000000002012-05 174.0000000000
WORK0055266602 3 28090 300.00000000002012-06 126.0000000000


Fdate字段是变动的，我想得到如下结果：
请教如何实现，谢谢！

Fbillno Finterid Fstatus Fitemid Fauxqty 2012-05 2012-06 Fqty
 
WORK0055256595 3 28086 100.0000000000 100 0 100
WORK0055266602 3 28090 300.0000000000 174 126 300

[解决办法]
http://wenku.baidu.com/view/66ff110ef78a6529647d530c.html
[解决办法]
http://blog.csdn.net/dba_huangzj/article/details/7530928我总结了一下例子，看看能不能帮上忙
[解决办法]

SQL code

--> 测试数据：[test]if object_id('[test]') is not null drop table [test]create table [test]([Fbillno] varchar(10),[Finterid] int,[Fstatus] int,[Fitemid] int,[Fauxqty] numeric(13,10),[Fdate] varchar(7),[Fqty] numeric(5,2))goinsert [test]select 'WORK005525',6595,3,28086,100.0000000000,'2012-05',100.00 union allselect 'WORK005526',6602,3,28090,300.0000000000,'2012-05',174.00 union allselect 'WORK005526',6602,3,28090,300.0000000000,'2012-06',126.00declare @str varchar(2000)set @str=''select     @str=@str+',['+[Fdate]    +']=max(case when [Fdate]='    +quotename([Fdate],'''')+' then [Fqty] else 0 end)'from     testgroup by     [Fdate]print @strset @str='select Fbillno,Finterid,Fstatus,Fitemid,Fauxqty'     +@str+',sum(Fqty) as Fqty from test      group by Fbillno,Finterid,Fstatus,Fitemid,Fauxqty'exec(@str)/*Fbillno    Finterid    Fstatus    Fitemid    Fauxqty    2012-05    2012-06    Fqty------------------------------------------WORK005525    6595    3    28086    100.0000000000    100.00    0.00    100.00WORK005526    6602    3    28090    300.0000000000    174.00    126.00    300.00*/
[解决办法]
select fbillno,finterid,fstatus,fitemid,fauxqty,
max(case when fdate='2012-05'then fqty else 0 end)[2012-05],
max(case when fdate='2012-06'then fqty else 0 end)[2012-06],
sum(fqty)[fqty]
from test group by fbillno,finterid,fstatus,fitemid,fauxqty