向各位请问怎么做这样一个交叉报表

@maxDate=max(convert(varchar(7),[日期],102))+'.01'改為@maxDate=max(convert(varchar(7),getdate(),102))+'.01'
------解决方案--------------------
SQL code
--> (让你望见影子的墙)生成测试数据，时间：2009-03-13 if not object_id('tb') is null    drop table tbGoCreate table tb([物料编码] nvarchar(3),[供应商ID] nvarchar(4),[日期] datetime,[单价] decimal(18,1))Insert tbselect N'001',N'A011','2008.3.1',1.3 union allselect N'001',N'A011','2008.7.9',1.5 union allselect N'001',N'A011','2008.12.1',1.1GoSelect * from tbdrop table #select id=identity(int ,1,1),*  into # from tb order by 物料编码,供应商id,日期 select * from #select  物料编码,供应商id,        [2008-1]=case when '2008-1-1'<=(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-1-13' order by 日期 desc)                 end,        [2008-2]=case when '2008-2-1'<=(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-2-28' order by 日期 desc)                 end,        [2008-3]=case when '2008-3-1'<=(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-3-31' order by 日期 desc)                 end,        [2008-4]=case when '2008-4-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-4-30' order by 日期 desc)                 end,        [2008-5]=case when '2008-5-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-5-31' order by 日期 desc)                 end,        [2008-6]=case when '2008-6-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-6-30' order by 日期 desc)                 end,        [2008-7]=case when '2008-7-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-7-31' order by 日期 desc)                 end,        [2008-8]=case when '2008-8-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-8-31' order by 日期 desc)                 end,        [2008-9]=case when '2008-9-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-9-30' order by 日期 desc)                 end,        [2008-10]=case when '2008-10-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-10-31' order by 日期 desc)                 end,        [2008-11]=case when '2008-11-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-11-30' order by 日期 desc)                 end,        [2008-12]=case when '2008-12-1'<(select 日期 from # where id=1)                      then (select 单价 from # where id=1)                      else (select top 1 单价 from # t where t.物料编码=s.物料编码 and t.供应商id=s.供应商id and 日期<='2008-12-31' order by 日期 desc)                 endfrom # sgroup by 物料编码,供应商id001    A011    1.3    1.3    1.3    1.3    1.3    1.3    1.5    1.5    1.5    1.5    1.5    1.1