游标

 

数据表
if exists (select * from sysobjects where id = OBJECT_ID('[aa1]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [aa1]

CREATE TABLE [aa1] (
[费用ID] [decimal] (12,0) NOT NULL,
[费用类型] [char] (2) NULL,
[户号] [int] NULL,
[金额] [decimal] (13,3) NULL,
[生成工号] [int] NULL,
[生成日期] [datetime] NULL,
[滞纳金日期] [datetime] NULL,
[滞纳金] [decimal] (10,2) NULL,
[销帐工号] [int] NULL,
[销帐日期] [datetime] NULL,
[实收方式] [char] (2) NULL,
[供水公司] [char] (3) NULL,
[户名] [varchar] (60) NULL,
[地址] [varchar] (60) NULL,
[表位号] [char] (13) NULL,
[表身号] [varchar] (10) NULL,
[口径] [int] NULL,
[收费方式] [char] (2) NULL,
[帐户编号] [int] NULL,
[税号] [varchar] (20) NULL,
[打印发票] [bit] NOT NULL,
[标志] [char] (1) NULL,
[备注] [varchar] (254) NULL,
[滞纳金结算日] [datetime] NULL,
[处理类型] [varchar] (50) NULL,
[处理费用ID] [decimal] (12,0) NULL,
[处理标志] [varchar] (2) NULL,
[销帐时间] [datetime] NULL)

INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 1338929,'SF',47043,17.660,105,'2004-10-3 00:00:00','2008-11-2 00:00:00',0.00,63,'2008-10-26 00:00:00','XJ','G01','陈仕连','东湖东路','ACL0060-00245','Z64715',20,'XJ',1,'X','2008-10-26 00:00:00','2008-10-26 15:45:59')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 1353449,'SF',16363,33.710,106,'2004-11-4 00:00:00','2008-12-2 00:00:00',0.00,64,'2008-11-25 00:00:00','XJ','G01','张桂兰','泰和商住楼1期2B7','CCL0014-00315','Z14769',15,'XJ',1,'X','2008-11-25 00:00:00','2008-11-25 08:21:03')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 43118,'SF',12790,6.420,102,'2007-10-13 00:00:00','2007-10-28 00:00:00',0.00,56,'2007-11-29 00:00:00','XJ','G01','谢强','钢铁公司','BCL0023-00303','Z11610',15,'XJ',1,'X','输入实收水量的原因:错表底','2007-11-29 00:00:00','2007-11-29 09:59:17')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 42553,'SF',25599,20.870,106,'2007-10-15 00:00:00','2007-10-28 00:00:00',0.00,70,'2007-11-12 00:00:00','XJ','G01','张广友','水电','CCL0040-00305','Z22982',15,'XJ',1,'X','输入实收水量的原因:本期行至错','2007-11-12 00:00:00','2007-11-12 14:50:59')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1934,'SF',30,123.300,99998,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-13 00:00:00','XJ','G01','蔡露珠','北坛','BCL0008-00001','Z00029',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-13 00:00:00','2007-11-13 16:12:48')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1935,'SF',52,37.490,99998,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,80,'2007-11-28 00:00:00','XJ','G01','苏佐任','BCL0008-00002','Z00043',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-28 00:00:00','2007-11-28 08:50:34')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1936,'SF',61,20.870,99998,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,75,'2007-11-29 00:00:00','XJ','G01','苏英锋','BCL0008-00003','Z00051',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-29 00:00:00','2007-11-29 12:57:58')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1937,'SF',69,28.890,99998,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-12 00:00:00','XJ','G01','苏英安','BCL0008-00004','Z00056',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-12 00:00:00','2007-11-12 09:03:17')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1938,'SF',79,32.100,99998,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,77,'2007-11-28 00:00:00','XJ','G01','苏平','BCL0008-00005','Z00063',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-28 00:00:00','2007-11-28 09:35:13')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1939,'SF',84,57.540,99998,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-23 00:00:00','XJ','G01','何铁芬','城东大道237号','BCL0008-00006','Z00075',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-23 00:00:00','2007-11-23 14:10:46')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1940,'SF',95,79.460,99998,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-21 00:00:00','XJ','G01','杨献坤','城东大道235号','BCL0008-00007','Z00084',15,'XJ',1,'X','输入实收水量的原因:.','2007-11-21 00:00:00','2007-11-21 13:40:01')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 1941,'SF',242,46.580,99998,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-20 00:00:00','XJ','G01','李永良','BCL0008-00015','Z00228',15,'XJ',1,'X','输入实收水量的原因:换新表','2007-11-20 00:00:00','2007-11-20 15:41:49')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31186,'SF',3220,20.870,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-27 00:00:00','XJ','G01','杨丽容','玫瑰园','BCL0008-00378','Z03028',15,'XJ',1,'X','2007-11-27 00:00:00','2007-11-27 14:39:17')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31194,'SF',3235,32.100,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,73,'2007-11-30 00:00:00','XJ','G01','沙起','玫瑰园','BCL0008-00379','Z03051',15,'XJ',1,'X','2007-11-30 00:00:00','2007-11-30 10:29:55')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31197,'SF',3252,28.890,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-15 00:00:00','XJ','G01','杨太生','玫瑰园','BCL0008-00380','Z03058',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 15:33:17')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 31210,'SF',3260,46.550,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-10 00:00:00','XJ','G01','蓝殿辉','玫瑰园','BCL0008-00381','Z39609',20,'XJ',1,'X','输入实收水量的原因:表停估收','2007-11-10 00:00:00','2007-11-10 15:42:39')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31212,'SF',3271,40.130,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,56,'2007-12-2 00:00:00','XJ','G01','周远闻','玫瑰园','BCL0008-00382','Z03078',15,'XJ',1,'X','2007-12-2 00:00:00','2007-12-2 15:10:17')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31214,'SF',3284,14.450,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-12 00:00:00','XJ','G01','李月媛','玫瑰园','BCL0008-00383','Z03086',15,'XJ',1,'X','2007-11-12 00:00:00','2007-11-12 11:53:08')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31217,'SF',3290,12.840,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-23 00:00:00','XJ','G01','谢日芬','玫瑰园','BCL0008-00384','Z03089',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 14:55:53')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31219,'SF',3294,62.600,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-17 00:00:00','XJ','G01','杨育林','玫瑰园','BCL0008-00385','Z03101',15,'XJ',1,'X','2007-11-17 00:00:00','2007-11-17 10:21:55')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31221,'SF',3309,30.500,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-27 00:00:00','XJ','G01','麦炳志','玫瑰园','BCL0008-00386','Z03118',15,'XJ',1,'X','2007-11-27 00:00:00','2007-11-27 15:20:09')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31222,'SF',3325,43.340,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-25 00:00:00','XJ','G01','岑贤其','玫瑰园','BCL0008-00387','Z03126',15,'XJ',1,'X','2007-11-25 00:00:00','2007-11-25 10:01:49')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31224,'SF',3333,49.760,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,56,'2007-12-2 00:00:00','XJ','G01','陈富泉','玫瑰园','BCL0008-00388','Z03139',15,'XJ',1,'X','2007-12-2 00:00:00','2007-12-2 11:44:59')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31225,'SF',3348,22.470,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-18 00:00:00','XJ','G01','岑春梅','玫瑰园','BCL0008-00389','Z03151',15,'XJ',1,'X','2007-11-18 00:00:00','2007-11-18 09:02:42')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31228,'SF',3359,81.860,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-15 00:00:00','XJ','G01','黄国庆','玫瑰园','BCL0008-00390','Z03158',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 16:24:08')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31230,'SF',3367,19.260,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-17 00:00:00','XJ','G01','叶德烈','玫瑰园','BCL0008-00391','Z03167',15,'XJ',1,'X','2007-11-17 00:00:00','2007-11-17 14:46:07')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31232,'SF',3377,57.780,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-14 00:00:00','XJ','G01','龙飘','玫瑰园','BCL0008-00392','Z03177',15,'YF',1,'X','2007-11-14 00:00:00','2007-11-14 08:22:39')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31238,'SF',3404,22.470,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-25 00:00:00','XJ','G01','周方权','玫瑰园','BCL0008-00394','Z03199',15,'XJ',1,'X','2007-11-25 00:00:00','2007-11-25 10:10:57')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31242,'SF',3412,14.450,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-12 00:00:00','XJ','G01','黄达','玫瑰园','BCL0008-00395','Z03209',15,'XJ',1,'X','2007-11-12 00:00:00','2007-11-12 14:40:23')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31245,'SF',3422,17.660,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-19 00:00:00','XJ','G01','黄敦浪','玫瑰园','BCL0008-00396','Z03216',15,'XJ',1,'X','2007-11-19 00:00:00','2007-11-19 14:19:37')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31247,'SF',3430,25.680,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-26 00:00:00','XJ','G01','张凤玲','玫瑰园','BCL0008-00397','Z39637',20,'XJ',1,'X','2007-11-26 00:00:00','2007-11-26 10:27:58')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31248,'SF',3440,40.130,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,74,'2007-11-28 00:00:00','XJ','G01','卢翠娟','玫瑰园','BCL0008-00398','Z03229',15,'XJ',1,'X','2007-11-28 00:00:00','2007-11-28 12:25:22')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31251,'SF',3448,56.180,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-22 00:00:00','XJ','G01','邓大埌','玫瑰园','BCL0008-00399','Z03237',15,'XJ',1,'X','2007-11-22 00:00:00','2007-11-22 10:10:07')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 31257,'SF',3456,19.260,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',3.82,80,'2008-1-23 00:00:00','XJ','G01','黄家全','玫瑰园','BCL0008-00400','Z03244',15,'XJ',1,'X','输入实收水量的原因:表停估收','2008-1-23 00:00:00','2008-1-23 10:49:34')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31269,'SF',3463,12.840,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-21 00:00:00','XJ','G01','徐正华','玫瑰园','BCL0008-00401','Z03259',15,'XJ',1,'X','2007-11-21 00:00:00','2007-11-21 10:15:00')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31276,'SF',3478,11.240,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',3.23,77,'2008-2-16 00:00:00','XJ','G01','罗立荣','玫瑰园','BCL0008-00402','Z03263',15,'XJ',1,'X','2008-2-16 00:00:00','2008-2-16 16:38:06')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31279,'SF',3492,30.500,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-15 00:00:00','XJ','G01','陈雪琴','东源楼','BCL0008-00404','Z03278',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 12:09:00')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31284,'SF',3514,28.890,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-11 00:00:00','XJ','G01','张建强','东源楼','BCL0008-00406','Z03298',15,'XJ',1,'X','2007-11-11 00:00:00','2007-11-11 09:42:22')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31287,'SF',3525,25.680,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-12 00:00:00','XJ','G01','孙圣多','东源楼','BCL0008-00407','Z03306',15,'XJ',1,'X','2007-11-12 00:00:00','2007-11-12 13:53:35')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31290,'SF',3534,11.240,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-19 00:00:00','XJ','G01','欧鸿亮','东源楼','BCL0008-00408','Z03320',15,'XJ',1,'X','2007-11-19 00:00:00','2007-11-19 14:46:41')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31296,'SF',3548,16.050,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',2.88,75,'2008-1-18 00:00:00','XJ','G01','王冠','东源楼','BCL0008-00409','Z03327',15,'XJ',1,'X','2008-1-18 00:00:00','2008-1-18 14:54:02')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31300,'SF',3579,49.760,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-17 00:00:00','XJ','G01','梁绍娟','东源楼','BCL0008-00411','Z03358',15,'XJ',1,'X','2007-11-17 00:00:00','2007-11-17 09:17:10')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31301,'SF',3585,27.290,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-23 00:00:00','XJ','G01','肖建军','东源楼','BCL0008-00412','Z03370',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 10:15:38')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31305,'SF',3601,20.870,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,77,'2007-11-30 00:00:00','XJ','G01','邓均华','东源楼','BCL0008-00413','Z03385',15,'XJ',1,'X','2007-11-30 00:00:00','2007-11-30 09:35:55')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志]) VALUES ( 31308,'SF',3615,17.660,102,'2007-11-1 00:00:00',0.00,555,'2007-11-29 00:00:00','SP','G01','覃嫦','东源楼','BCL0008-00414','Z03393',15,'XJ',1,'X')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31311,'SF',3623,20.870,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-15 00:00:00','XJ','G01','李行基','东源楼','BCL0008-00415','Z03400',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 12:08:25')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31313,'SF',3631,16.050,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-22 00:00:00','XJ','G01','刘敏','东源楼','BCL0008-00416','Z03411',15,'XJ',1,'X','2007-11-22 00:00:00','2007-11-22 16:35:21')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31315,'SF',3642,12.840,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.00,56,'2007-12-20 00:00:00','XJ','G01','冯格','东源楼','BCL0008-00417','Z03421',15,'XJ',1,'X','2007-12-20 00:00:00','2007-12-20 15:01:15')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31317,'SF',3651,12.840,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-23 00:00:00','XJ','G01','严进燕','东源楼','BCL0008-00418','Z03432',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 15:49:43')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31318,'SF',3663,30.500,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-15 00:00:00','XJ','G01','李康有','东源楼','BCL0008-00419','Z03442',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 10:16:45')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31319,'SF',3674,32.100,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-19 00:00:00','XJ','G01','梁志林','东源楼','BCL0008-00420','Z03450',15,'XJ',1,'X','2007-11-19 00:00:00','2007-11-19 14:36:21')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31323,'SF',3681,19.260,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-13 00:00:00','XJ','G01','钟文义','东源楼','BCL0008-00421','Z03460',15,'XJ',1,'X','2007-11-13 00:00:00','2007-11-13 09:27:26')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31324,'SF',3691,11.240,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,56,'2007-11-30 00:00:00','XJ','G01','刘苗','东源楼','BCL0008-00422','Z03467',15,'XJ',1,'X','2007-11-30 00:00:00','2007-11-30 14:30:21')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31325,'SF',3698,19.260,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.30,56,'2007-12-20 00:00:00','XJ','G01','冯格','东源楼','BCL0008-00423','Z03475',15,'XJ',1,'X','2007-12-20 00:00:00','2007-12-20 15:15:49')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31326,'SF',3707,24.080,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-16 00:00:00','XJ','G01','严仕玲','东源楼','BCL0008-00424','Z03480',15,'XJ',1,'X','2007-11-16 00:00:00','2007-11-16 09:38:18')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31327,'SF',3712,14.450,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.00,75,'2007-12-20 00:00:00','XJ','G01','梁志强','东源楼','BCL0008-00425','Z03488',15,'XJ',1,'X','2007-12-20 00:00:00','2007-12-20 16:04:45')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31329,'SF',3733,16.050,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-24 00:00:00','XJ','G01','黄新华','东源楼','BCL0008-00428','Z03509',15,'XJ',1,'X','2007-11-24 00:00:00','2007-11-24 12:12:13')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31331,'SF',3742,0.000,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,74,'2007-12-29 00:00:00','XJ','G01','谢艳芳','东源楼','BCL0008-00429','Z03517',15,'XJ',1,'X','2007-12-29 00:00:00','2007-12-29 16:43:18')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日]) VALUES ( 31334,'SF',3749,9.630,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,101,'2007-12-5 00:00:00','SP','G01','张锐华','东源楼','BCL0008-00430','Z03524',15,'XJ',1,'X','2007-11-20 00:00:00')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31338,'SF',3757,19.260,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-15 00:00:00','XJ','G01','练桂芹','东源楼','BCL0008-00431','Z03536',15,'XJ',1,'X','2007-11-15 00:00:00','2007-11-15 14:57:04')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31340,'SF',3769,24.080,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-21 00:00:00','XJ','G01','欧远辉','东源楼','BCL0008-00432','Z03544',15,'XJ',1,'X','2007-11-21 00:00:00','2007-11-21 12:57:49')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31342,'SF',3777,16.050,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-16 00:00:00','XJ','G01','梁志峰','东源楼','BCL0008-00433','Z03555',15,'XJ',1,'X','2007-11-16 00:00:00','2007-11-16 10:08:26')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31344,'SF',3787,52.970,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-10 00:00:00','XJ','G01','黄小红','东源楼','BCL0008-00434','Z03566',15,'XJ',1,'X','2007-11-10 00:00:00','2007-11-10 11:23:41')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[备注],[滞纳金结算日]) VALUES ( 31348,'SF',3798,0.000,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,'G01','东源楼消防表','东源楼','BCL0008-00435','Z43555',50,'XJ',1,'输入实收水量的原因:本期行至错','2010-4-24 00:00:00')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31353,'SF',3807,20.870,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-13 00:00:00','XJ','G01','罗瑞东','东源楼','BCL0008-00436','Z03579',15,'XJ',1,'X','2007-11-13 00:00:00','2007-11-13 10:30:48')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31358,'SF',3824,40.130,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-14 00:00:00','XJ','G01','黄华','东源楼','BCL0008-00437','Z03590',15,'XJ',1,'X','2007-11-14 00:00:00','2007-11-14 15:48:38')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31361,'SF',3829,40.130,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-12 00:00:00','XJ','G01','李泳','东源楼','BCL0008-00438','Z03601',15,'XJ',1,'X','2007-11-12 00:00:00','2007-11-12 11:09:12')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31363,'SF',3842,28.890,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',2.48,56,'2007-12-25 00:00:00','XJ','G01','冯世浓','东源楼','BCL0008-00439','Z03608',15,'XJ',1,'X','2007-12-25 00:00:00','2007-12-25 16:45:52')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31368,'SF',3849,49.760,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-23 00:00:00','XJ','G01','黄仕浓','东源楼','BCL0008-00440','Z03613',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 10:52:10')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31371,'SF',3854,14.450,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-23 00:00:00','XJ','G01','林佳欣','东源楼','BCL0008-00441','Z03621',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 09:10:47')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[备注],[滞纳金结算日],[销帐时间]) VALUES ( 31377,'SF',3863,0.000,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,56,'2008-7-4 00:00:00','XJ','G01','黄淮正','东源楼','BCL0008-00442','Z03635',15,'XJ',1,'X','输入实收水量的原因:欠费拆表','2008-7-4 00:00:00','2008-7-4 16:45:18')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[滞纳金结算日],[销帐时间]) VALUES ( 31383,'SF',3876,0.000,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,'XJ','G01','陈怀有','东源楼','BCL0008-00443','Z03648',15,'XJ',1,'2010-6-10 00:00:00','2010-6-10 12:22:08')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31385,'SF',3889,0.000,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,66,'2008-5-16 00:00:00','XJ','G01','电信局','东源楼','BCL0008-00444','Z03655',15,'XJ',1,'X','2008-5-16 00:00:00','2008-5-16 14:52:56')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31388,'SF',3895,8.030,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-26 00:00:00','XJ','G01','张才','东源楼','BCL0008-00445','Z03659',15,'XJ',1,'X','2007-11-26 00:00:00','2007-11-26 15:29:43')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31394,'SF',3899,41.730,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-25 00:00:00','XJ','G01','刘运锋','东源楼','BCL0008-00446','Z03663',15,'XJ',1,'X','2007-11-25 00:00:00','2007-11-25 14:29:57')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31396,'SF',3903,52.970,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-23 00:00:00','XJ','G01','李大清','东源楼','BCL0008-00447','Z39661',20,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 10:06:45')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31398,'SF',3906,25.680,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-24 00:00:00','XJ','G01','林道权','东源楼','BCL0008-00448','Z03670',15,'XJ',1,'X','2007-11-24 00:00:00','2007-11-24 13:03:25')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31399,'SF',3910,41.730,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-26 00:00:00','XJ','G01','吴志英','东源楼','BCL0008-00449','Z03674',15,'XJ',1,'X','2007-11-26 00:00:00','2007-11-26 14:23:19')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[帐户编号],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31402,'SF',3915,59.390,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-17 00:00:00','XJ','G01','陈金秀','东源楼','BCL0008-00450','Z39662',20,'CZ',2242,1,'X','2007-11-17 00:00:00','2007-11-17 15:27:27')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31403,'SF',3921,59.390,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',3.80,74,'2007-12-19 00:00:00','XJ','G01','刘建敏','东源楼','BCL0008-00451','Z39671',20,'YF',1,'X','2007-12-19 00:00:00','2007-12-19 12:46:39')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志]) VALUES ( 31404,'SF',3927,19.260,102,'2007-11-1 00:00:00',0.00,84,'2008-2-21 00:00:00','SP','G01','姜梅珍','东源楼','BCL0008-00452','Z03688',15,'XJ',1,'X')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31405,'SF',3933,33.710,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',10.96,76,'2008-2-26 00:00:00','XJ','G01','曾周','东源楼','BCL0008-00453','Z03696',15,'XJ',1,'X','2008-2-26 00:00:00','2008-2-26 14:56:41')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31406,'SF',3941,41.730,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.00,74,'2007-12-3 00:00:00','XJ','G01','韦亦春','东源楼','BCL0008-00454','Z39672',20,'XJ',1,'X','2007-12-3 00:00:00','2007-12-3 10:01:09')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31407,'SF',3951,38.520,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,76,'2007-11-13 00:00:00','XJ','G01','刘锋','东源楼','BCL0008-00455','Z03714',15,'XJ',1,'X','2007-11-13 00:00:00','2007-11-13 08:54:51')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31409,'SF',3963,56.180,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,74,'2007-11-28 00:00:00','XJ','G01','马小文','东源楼','BCL0008-00456','Z39673',20,'XJ',1,'X','2007-11-28 00:00:00','2007-11-28 13:32:35')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31410,'SF',3967,44.940,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.00,80,'2007-12-4 00:00:00','XJ','G01','陈粤江','东源楼','BCL0008-00457','Z03728',15,'XJ',1,'X','2007-12-4 00:00:00','2007-12-4 14:35:45')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31411,'SF',3975,20.870,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-18 00:00:00','XJ','G01','韦亦鹏','东源楼','BCL0008-00458','Z03734',15,'XJ',1,'X','2007-11-18 00:00:00','2007-11-18 10:19:42')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31412,'SF',3981,32.100,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-23 00:00:00','XJ','G01','谢日升','东源楼','BCL0008-00459','Z03739',15,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 12:04:56')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31413,'SF',3986,30.500,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-14 00:00:00','XJ','G01','李良','东源楼','BCL0008-00460','Z03747',15,'XJ',1,'X','2007-11-14 00:00:00','2007-11-14 10:09:58')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31414,'SF',3994,22.470,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',0.00,73,'2007-11-30 00:00:00','XJ','G01','欧开军','东源楼','BCL0008-00461','Z03776',15,'XJ',1,'X','2007-11-30 00:00:00','2007-11-30 10:22:47')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31416,'SF',4023,20.870,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-23 00:00:00','XJ','G01','植天和','东源楼','BCL0008-00462','Z39674',20,'XJ',1,'X','2007-11-23 00:00:00','2007-11-23 10:49:38')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31417,'SF',4032,40.130,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,56,'2007-11-27 00:00:00','XJ','G01','林斌','东源楼','BCL0008-00463','Z03791',15,'XJ',1,'X','2007-11-27 00:00:00','2007-11-27 08:43:46')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31418,'SF',4038,12.840,102,'2007-11-1 00:00:00','2007-12-2 00:00:00',1.00,76,'2007-12-7 00:00:00','XJ','G01','陈欢','东源楼','BCL0008-00464','Z03798',15,'XJ',1,'X','2007-12-7 00:00:00','2007-12-7 10:21:42')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31419,'SF',4046,36.920,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,80,'2007-11-12 00:00:00','XJ','G01','刘学强','东源楼','BCL0008-00465','Z03802',15,'XJ',1,'X','2007-11-12 00:00:00','2007-11-12 08:53:33')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31420,'SF',4052,8.030,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-13 00:00:00','XJ','G01','梁才文','东源楼','BCL0008-00466','Z39678',20,'XJ',1,'X','2007-11-13 00:00:00','2007-11-13 16:04:20')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31421,'SF',4059,49.760,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,77,'2007-11-13 00:00:00','XJ','G01','蔡舒敏','东源楼','BCL0008-00467','Z03829',15,'XJ',1,'X','2007-11-13 00:00:00','2007-11-13 16:06:23')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31423,'SF',4085,109.140,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-24 00:00:00','XJ','G01','韦其响','东源楼','BCL0008-00468','Z03835',15,'XJ',1,'X','2007-11-24 00:00:00','2007-11-24 11:26:06')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31424,'SF',4092,11.240,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,75,'2007-11-20 00:00:00','XJ','G01','叶雪玲','东源楼','BCL0008-00469','Z39685',20,'XJ',1,'X','2007-11-20 00:00:00','2007-11-20 16:58:48')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31425,'SF',4102,11.240,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,74,'2007-11-24 00:00:00','XJ','G01','翁伙壬','东源楼','BCL0008-00470','Z39692',20,'XJ',1,'X','2007-11-24 00:00:00','2007-11-24 14:07:38')
INSERT [aa1] ([费用ID],[费用类型],[户号],[金额],[生成工号],[生成日期],[滞纳金日期],[滞纳金],[销帐工号],[销帐日期],[实收方式],[供水公司],[户名],[地址],[表位号],[表身号],[口径],[收费方式],[打印发票],[标志],[滞纳金结算日],[销帐时间]) VALUES ( 31426,'SF',4111,30.500,102,'2007-11-1 00:00:00','2007-11-28 00:00:00',0.00,73,'2007-11-17 00:00:00','XJ','G01','谢汝钦','东源楼','BCL0008-00471','Z03856',15,'XJ',1,'X','2007-11-17 00:00:00','2007-11-17 14:20:09')

在数据库中,游标是一个十分重要的概念。游标提供了一种对从表中检索出的数据进行操作的灵活手段,就本质而言,游标实际上是一种能从包括多条数据记录的结果集中每次提取一条记录的机制。游标总是与一条T_SQL 选择语句相关联,因为游标由结果集(可以是零条、一条或由相关的选择语句检索出的多条记录)和结果集中指向特定记录的游标位置组成。

当决定对结果集进行处理时,必须声明一个指向该结果集的游标。如果曾经用 C 语言写过对文件进行处理的程序,那么游标就像您打开文件所得到的文件句柄一样,只要文件打开成功,该文件句柄就可代表该文件。对于游标而言,其道理是相同的。可见游标能够实现按与传统程序读取平面文件类似的方式处理来自基础表的结果集,从而把表中数据以平面文件的形式呈现给程序。

我们知道关系数据库管理系统实质是面向集合的,在MS SQL SERVER 中并没有一种描述表中单一记录的表达形式,除非使用where 子句来限制只有一条记录被选中。因此我们必须借助于游标来进行面向单条记录的数据处理。
    
由此可见,游标允许应用程序对查询语句select 返回的行结果集中每一行进行相同或不同的操作,而不是一次对整个结果集进行同一种操作;它还提供对基于游标位置而对表中数据进行删除或更新的能力;而且,正是游标把作为面向集合的数据库管理系统和面向行的程序设计两者联系起来,使两个数据处理方式能够进行沟通。

每一个游标必须有四个组成部分这四个关键部分必须符合下面的顺序;

1.DECLARE 游标
2.OPEN 游标
3.从一个游标中FETCH 信息
4.CLOSE 或DEALLOCATE 游标

通常我们使用DECLARE 来声明一个游标声明一个游标主要包括以下主要内容:

游标名字
数据来源(表和列)
选取条件
属性(仅读或可修改)
其语法格式如下:

DECLARE cursor_name [INSENSITIVE] [SCROLL] CURSOR
FOR select_statement
[FOR {READ ONLY | UPDATE [OF column_name [,...n]]}]

其中:
cursor_name 指游标的名字。

INSENSITIVE

表明MS SQL SERVER 会将游标定义所选取出来的数据记录存放在一临时表内(建立在tempdb 数据库下)。对该游标的读取操作皆由临时表来应答。因此,对基本表的修改并不影响游标提取的数据,即游标不会随着基本表内容的改变而改变,同时也无法通过游标来更新基本表。如果不使用该保留字,那么对基本表的更新、删除都会反映到游标中。

游标指针示意图

SQL <wbr>SERVER <wbr>游标(Cursor)(转)

详细:

1.定义一个标准游标:

declare mycursor cursor for select * from aa1

2.定义一个只读游标:

declare mycursor cursor for select * from aa1 for read only

3.定义一个可写游标:

declare mycursor1 cursor for select * from aa1 for update  

姓名,性别,年龄,基本工资,奖金,所得税,应发工资
注: scroll 只能对只读游标起作用

4.打开游标:open 游标名

如:

declare mycursor cursor for select * from aa1
open mycursor

5.从游标中取数据:fetch,默认情况下,指针指向第一条记录之前

移动记录指针的方法:
NEXT   下移一条记录
prior 上移一条记录
first 第一条记录
LAST   最后一条记录
absolute n 绝对记录 第N条记录

取数据语法:

fetch next|prior|first|last|absolute|RELATIVE n    from 游标名 [into 变量名列表]

6.关闭游标: close 游标名
暂时关闭游标,还可再使用OPEN打开.

7.释放游标: deallocate 游标名

从内存中清除游标.如果还想使用,必须再次声明.

对当前游标状态进行判断:

8. @@fetch_status 如果返回是0,说明当前操作是成功的.否则是失败的.
0 FETCH 语句成功。
-1 FETCH 语句失败或此行不在结果集中。
-2 被提取的行不存在。

 --------------------------------------------------------------------------------------------------------------------------------------------

posted @ 2010-10-25 13:36  qanholas  阅读(934)  评论(0编辑  收藏  举报