我要循环几十个表,把几十个表中的同一字段求和,
我有一个表t1存着几十个表的表名
我在存储过程中是这样写的
declare @summoney numeric(18,4)
declare @sumnumber numeric(18,4)
declare @tablename varchar(50)
declare cur_Table CURSOR
for select tablename from t1
OPEN cur_Table
FETCH Next FROM cur_Table INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
//这里是问题所在????
exec ('select sum(Money),sum(number) from '+@TableName)
//?????我怎么把求出sum(Money),sum(number)付给@summoney和@sumnumber
FETCH Next FROM cur_Table INTO @TableName
end
我有一个表t1存着几十个表的表名
我在存储过程中是这样写的
declare @summoney numeric(18,4)
declare @sumnumber numeric(18,4)
declare @tablename varchar(50)
declare cur_Table CURSOR
for select tablename from t1
OPEN cur_Table
FETCH Next FROM cur_Table INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
//这里是问题所在????
exec ('select sum(Money),sum(number) from '+@TableName)
//?????我怎么把求出sum(Money),sum(number)付给@summoney和@sumnumber
FETCH Next FROM cur_Table INTO @TableName
end
解决方案 »
- 如何实现cxGridDBTableView的固定列????
- 在构造函数中为什么不能给属性赋值?
- 哈哈 第一次赌, 就赢了 150 多分...................................
- quickrep中如何显示excel表的某个区域的内容?例如A1-B7区域。头一回做报表,大家帮帮忙!
- 感谢杨小凯,特此放分!! ̄ ̄
- 如何在主线程中判断一个线程已经结束了
- 李维《ADO、MTS、COM+高级程序设计》第三章,TOleContainer控件能显示存在数据库Blob字段中的mpg文件吗?
- 怎样用delphi编写内嵌的读写word的编辑器
- DELPHI问题 关于注册表
- 大家有兴趣去主页看看,刚做的!厚脸皮来推销!
- 简单问题,用adoquery控件连接数据库它提示missing sql property?是怎麽回事
- 用Indy 控件写一个Telnet的dll 出现的问题?急急 !!!
[交流]动态SQL语句
(
fsummoney numeric(18,4)
fsumnumber numeric(18,4)
ftablename varchar(50)
)declare cur_Table CURSOR
for select tablename from t1
OPEN cur_Table
FETCH Next FROM cur_Table INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
exec ('select sum(Money),sum(number),'''+@TableName+'''
into tSumMoney from '+@TableName)
FETCH Next FROM cur_Table INTO @TableName
end
/*
这里添加对结果表(tSumMoney)的处理
*/
drop table tSumMoney
declare @sumnumber numeric(18,4)
declare @tablename varchar(50) ,
@ldc_je decimal(18,4),
@ldc_sl numeric(18,4)declare cur_Table CURSOR
for select tablename from t1
OPEN cur_Table
FETCH Next FROM cur_Table INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
//这里是问题所在????
exec ('select @ldc_je = sum(Money), @ldc_sl = sum(number) from '+@TableName)
//?????我怎么把求出sum(Money),sum(number)付给@summoney和@sumnumber
set @summoney = @summoney + @ldc_je
set @sumnumber = @sumnumber + @ldc_je
FETCH Next FROM cur_Table INTO @TableName
end
exec sp_executesql 'select @ldc_je = sum(Money), @ldc_sl = sum(number) from '+@TableName , N'@ls_tbname numeric(18,4) output ,@ldc_sl numeric(18,4) output' , @ls_Tbname output , @ldc_sl output