select case when States=1 then N'总合计' else pianqu end as pianqu,
case when Citys=1 then N'合计' else fahuodanwei end as fahuodanwei,
maozhong,pizhong,jingzhong,ykl,hangshu
from (
select pianqu,fahuodanwei,sum(maozhong) as maozhong,sum(pizhong) as pizhong,sum(jingzhong) as jingzhong,sum(ykl) as ykl ,sum(hangshu) as hangshu ,Grouping(pianqu) as States,Grouping(fahuodanwei) as Citys
from sysdb
where gbsj between '2012-03-01 00:00:00' and '2012-03-31 23:59:59'
group by pianqu,fahuodanwei with rollup) q
大家好,我想在程序里通过赋值的方式把上面的sql语句赋值给变量sqlstr,并且把两个时间段分别用变量ts1和ts2表示应该怎样改?
ts1:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date)+' '+FormatDateTime ('hh:mm:ss',DateTimePicker3.Time); ts2:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date)+' '+FormatDateTime('hh:mm:ss',DateTimePicker4.Time);
ADOQuery6.Close;
ADOQuery6.SQL.Clear;
ADOQuery6.SQL.add(sqlstr)
........
我怎么改也改不好,
case when Citys=1 then N'合计' else fahuodanwei end as fahuodanwei,
maozhong,pizhong,jingzhong,ykl,hangshu
from (
select pianqu,fahuodanwei,sum(maozhong) as maozhong,sum(pizhong) as pizhong,sum(jingzhong) as jingzhong,sum(ykl) as ykl ,sum(hangshu) as hangshu ,Grouping(pianqu) as States,Grouping(fahuodanwei) as Citys
from sysdb
where gbsj between '2012-03-01 00:00:00' and '2012-03-31 23:59:59'
group by pianqu,fahuodanwei with rollup) q
大家好,我想在程序里通过赋值的方式把上面的sql语句赋值给变量sqlstr,并且把两个时间段分别用变量ts1和ts2表示应该怎样改?
ts1:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date)+' '+FormatDateTime ('hh:mm:ss',DateTimePicker3.Time); ts2:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.Date)+' '+FormatDateTime('hh:mm:ss',DateTimePicker4.Time);
ADOQuery6.Close;
ADOQuery6.SQL.Clear;
ADOQuery6.SQL.add(sqlstr)
........
我怎么改也改不好,
解决方案 »
- 昨晚8点多,在深圳明显有震感,楼房在摇晃?
- 请问:在深圳有没有DELPHI方面的培训?
- 在线等,急!!!解决立即给分
- 怎样手动设定StringGrid中每一列的宽度?
- 如何合并2个STRINGSTREAM中的内容(50分)
- 懂组件事件的‘调度方法’(Event-Dispatching Method)的高手请进!!!!!!!!!!!!!!!!
- ado+sqlserver 的问题
- 我是初学DELPHI的小菜鸟,我有个问题
- sql语句中有没有计算两个数比率的函数例如 字段a=5 b=10 得出百份比为50%
- 小谢的问题,从来都很好回答。进来看看吧
- 求助——关于线程!
- sql 语句定义的变量如何在delphi中执行
其它地方,1个单引号变2个
+' case when Citys=1 then N''合计'' else fahuodanwei end as fahuodanwei, '
+' maozhong,pizhong,jingzhong,ykl,hangshu '
+ ' from ( '
+ ' select pianqu,fahuodanwei,sum(maozhong) as maozhong,sum(pizhong) as pizhong,sum(jingzhong) as jingzhong,sum(ykl) as ykl ,sum(hangshu) as hangshu ,Grouping(pianqu) as States,Grouping(fahuodanwei) as Citys '
+ ' from sysdb '
+ ' where gbsj between '+quotedStr(ts1)+' and '+quotedStr(ts2)
+ ' group by pianqu,fahuodanwei with rollup) q ';
adoquery.Open();