ALTER proc [dbo].[SearchTbByClassAndId]
@class varchar(16),
@cid int,
@addcount int output,
@lostcount int output,
@oldcount int outputas
declare @sql varchar(2048),@tbi int,@lastTableName varchar(18),@lastBeforeTableName varchar(18)set @tbi=0while @tbi<@cid
begin
set @lastTableName = @class +'_'+dbo.GetLastDay()+'_'+convert(varchar(2),@tbi) --昨天表名
set @lastBeforeTableName = @class +'_'+dbo.GetLastBeforeDay()+'_'+convert(varchar(2),@tbi) --前天表名
print @lasttablename
set @sql='select count(*) from '+@lastTableName+' where '+@lastTableName+'.Uid not in (select '+@lastBeforeTableName+'.Uid from '+@lastBeforeTableName+');'--新增用户exec (@sql)
在这里怎么能取到新增用户的个数呢
set @sql='select count(*) from '+@lastBeforeTableName+' where '+@lastBeforeTableName+'.Uid not in (select '+@lastTableName+'.Uid from '+@lastTableName+')' --流失用户
exec (@sql)
在这里怎么能取到新增用户的个数呢set @sql='select count(*) from '+@lastTableName+' inner join '+@lastBeforeTableName+' on '+@lastTableName+'.Uid='+@lastBeforeTableName+'.Uid' --稳定用户
exec (@sql)
在这里怎么能取到新增用户的个数呢set @tbi=@tbi+1
end 请大家帮忙啊,我能试的都试过了,还是取不到啊!
@class varchar(16),
@cid int,
@addcount int output,
@lostcount int output,
@oldcount int outputas
declare @sql varchar(2048),@tbi int,@lastTableName varchar(18),@lastBeforeTableName varchar(18)set @tbi=0while @tbi<@cid
begin
set @lastTableName = @class +'_'+dbo.GetLastDay()+'_'+convert(varchar(2),@tbi) --昨天表名
set @lastBeforeTableName = @class +'_'+dbo.GetLastBeforeDay()+'_'+convert(varchar(2),@tbi) --前天表名
print @lasttablename
set @sql='select count(*) from '+@lastTableName+' where '+@lastTableName+'.Uid not in (select '+@lastBeforeTableName+'.Uid from '+@lastBeforeTableName+');'--新增用户exec (@sql)
在这里怎么能取到新增用户的个数呢
set @sql='select count(*) from '+@lastBeforeTableName+' where '+@lastBeforeTableName+'.Uid not in (select '+@lastTableName+'.Uid from '+@lastTableName+')' --流失用户
exec (@sql)
在这里怎么能取到新增用户的个数呢set @sql='select count(*) from '+@lastTableName+' inner join '+@lastBeforeTableName+' on '+@lastTableName+'.Uid='+@lastBeforeTableName+'.Uid' --稳定用户
exec (@sql)
在这里怎么能取到新增用户的个数呢set @tbi=@tbi+1
end 请大家帮忙啊,我能试的都试过了,还是取不到啊!
解决方案 »
- 正则问题 ,急,来一下
- 好奇怪的问题?
- 基础问题:要网页中的字体凡是汉字都是宋体,凡是英文都是Arial,该怎么写?
- |M| 如何让DataView 只剩下前10条记录
- 在asp.net2.0中,如何将一个类(.cs)文件编译成.dll文件?
- 提示ConfigurationSettings.AppSettings 过期
- 请教,我在生成缩略图时,如果背景是透明色,生成的新图为什么是黑色?
- 在DreamweaverMX 2004里编辑中文后,保存再打开,就变成乱码了. IE显示页面也是乱码.有什么办法?
- 关于并发的问题。求指点
- asp.net1.0高级编程的C#代码无法下载?
- C#:用户编辑数据时,当用户改动了表单数据后退出时如何提示用户保存?
- asp.net 如何彈出打開對話框
ds.tables[0].rows[0][0].tostring();
ds.tables[1].rows[0][0].tostring();
ds.tables[2].rows[0][0].tostring();还有一种方法是采用存储过程的返回值
顺便给你一段代码:
set @ExcStr = ' select @CountNum=Count(*) from '+ @AreaName+ ' where WM_Account = '+ ''''+ @PARAM2 +''''+ ' and '+'Convert(varchar(8),Use_date,120) like '+''''+ @PARAM1+ '%'+ ''''
EXECUTE sp_executesql @ExcStr, N'@CountNum int output',@CountNum outputif(@CountNum > 0)
。
Declare @V_Count Int
Declare @sql nvarchar(4000)
set @sql = N'select @P_Count = count(*) from '+@lastTableName+' where '+@lastTableName+'.Uid not in (select '+@lastBeforeTableName+'.Uid from '+@lastBeforeTableName+');'--新增用户 Exec sp_executesql @sql, N'@P_Count Int Out', @V_Count OutPrint @V_Count