- 博客(3)
- 资源 (9)
- 收藏
- 关注
原创 20130427
select * from sf_bt where YEAR='2012' and cost != 0 and section=cost order by housecode; --42 select a.housecode from sf_bt a,(select housecode from sf_detail where chargemonth='2012') b where a.
2013-04-27 11:21:36 371
原创 整理SQL
update fc_temp_stop set 原房号=replace(原房号,'''',''); select c.housecode, c.房间编号,d.why from ( select housecode,房间编号 from (select distinct trim(a2.buildingname)||trim(a1.oldcode) as ttt,a1.housecod
2013-04-24 16:51:01 430
原创 初始欠费录入
select aa.收费期,aa.房间编号,aa.住户名称,'' as 交费单位,aa.使用类型,'A' as 收费项目, case when aa.使用类型 = '居民' then 'A01' else 'A02' end 收费标准,'1' as 表号面积编号, case when aa.使用类型 = '居民' then '28.00' else '33.00' end 单价,aa.面积,
2013-04-15 09:41:52 529
nginx配置tomcat
2013-01-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人