sql怎么写

[cjzm83]

表t
f1 f4
2010-01-01 3720
2010-01-15 300000
2010-02-8 16557
2010-02-23 104600

表s
m1-1 m1-2 m1-3 m2-1 m2-2 m2-3 其中m1-1代表一月份1-10号,m1-2(11-20号),类推..

要求根据表t字段f1的月份，天数插到表s对应的字段中，一个insert能搞定么
结果
表s
m1-1 m1-2 m1-3 m2-1 m2-2 m2-3
3720 300000 16557 2010-02-23

[永生天地]

可能是这样

insert 表s
select case when f1 between '2010-1-1' and '2010-1-10' then f4 else null end,
case when f1 between '2010-1-11' and '2010-1-20' then f4 else null end,
......
from 表t

[GOODlivelife]

if object_id('[t]') is not null drop table [t]
go
create table [t]([f1] datetime,[f4] int)
insert [t]
select '2010-01-01',3720 union all
select '2010-01-15',300000 union all
select '2010-02-8',16557 union all
select '2010-02-23',104600
go

select 
'm'+ltrim(month(f1))+'-'+ltrim((datepart(dd,f1)-1)/10+1) as m,f4
from t
/**
m                          f4
-------------------------- -----------
m1-1                       3720
m1-2                       300000
m2-1                       16557
m2-3                       104600

(4 行受影响)

**/

[GOODlivelife]

剩下的事情就是行列转换了