27,579
社区成员
发帖
与我相关
我的任务
分享
-- 利率表
create table TableLV
(
FID int null,
SDate datetime null,
Edate datetime null,
LV decimal(18,10) null
);
insert TableLV
select 1 ,'2013-01-01','2013-02-14',0.12
insert TableLV
select 2 ,'2013-02-15','2013-03-15',0.1
insert TableLV
select 3 ,'2013-03-15','2099-03-15',0.08
-- 存款表
create table TableTemp(
id int identity(1,1), --序号
FBillno varchar(50),
FName varchar(20),
FBaseName int,
BorrowDate datetime, --借款/还款日期
BMoney decimal(18,2), --借款/还款金额
)
insert TableTemp
select ' ','张三',249,'2012-12-29',82166.03
union select 'GZCD0000135','张三',249,'2013-01-21',11940.00
union select 'GZCD0000162','张三',249,'2013-02-05',300.00
union select 'GZCD0000136','张三',249,'2013-01-21',3876.40
union select 'GZCD0000171','张三',249,'2013-02-23',13864.00
union select 'GZCD0000172','张三',249,'2013-02-23',3431.20
union select 'GZCD0000189','张三',249,'2013-03-12',125000.00
union select 'GZCD0000205','张三',249,'2013-03-25',15667.00
union select 'GZCD0000206','张三',249,'2013-03-25',3601.60
union select 'GZCD0000226','张三',249,'2013-04-22',11916.00
union select 'GZCD0000227','张三',249,'2013-04-22',4980.80
select * from TableTemp