DECLARE @SQL NVARCHAR(2000)
--按地区得到各地区满意度调查3种不同结果出现的次数
set @SQL='select AreaId,Max(AreaName) AS AreaName,Replace(CustomerSatisfaction,'''','''') As CustomerSatisfaction,count(SurveryFilesId) As Score into #t from vw_SurveyInfoForArea
Where AreaName is not null AND StatusCode=1 AND DeletionStateCode=0 AND AreaDeletionStateCode=0 AND DATEDIFF(MONTH,SurveryMonth,''2008-01-01'')=0 AND DealerId=16 Group By AreaId,Replace(CustomerSatisfaction,'''','''')'
Exec sp_executesql @SQL
select * from #t
以上语句运行时报如下错误:(所影响的行数为 3 行)服务器: 消息 208,级别 16,状态 1,行 7
对象名 '#t' 无效。
哪位大侠帮忙指点一下?
--按地区得到各地区满意度调查3种不同结果出现的次数
set @SQL='select AreaId,Max(AreaName) AS AreaName,Replace(CustomerSatisfaction,'''','''') As CustomerSatisfaction,count(SurveryFilesId) As Score into #t from vw_SurveyInfoForArea
Where AreaName is not null AND StatusCode=1 AND DeletionStateCode=0 AND AreaDeletionStateCode=0 AND DATEDIFF(MONTH,SurveryMonth,''2008-01-01'')=0 AND DealerId=16 Group By AreaId,Replace(CustomerSatisfaction,'''','''')'
Exec sp_executesql @SQL
select * from #t
以上语句运行时报如下错误:(所影响的行数为 3 行)服务器: 消息 208,级别 16,状态 1,行 7
对象名 '#t' 无效。
哪位大侠帮忙指点一下?
解决方案 »
- SqlServer2000自定义函数中 float转换为字符型问题
- 多表查询与修改
- 数据库权限问题(SQL 2005)
- win7+sql2008下sa权限的问题
- 一个简单的问题
- 从子字符串与子字符串比较的问题
- 是不是SQL数据库问题
- Access转SQLServer以后数据库文件变大
- 第一次用SQL,前辈见笑了!
- 程序大哥们,我现在用sql server与delphi做图书馆管理系统,遇到一个问题。就是如何将远程sqlserver的数据库通过ADO备份到客户端,我在网看了好些资料,但没有具体给出用ADO的例子。可以的话帮帮我,小弟一定重分感谢。
- 初学者救助 用sql sever 2000 编写一个触发器的定义
- ssis包做好之后如何作业调度?
set @SQL=N'select AreaId,Max(AreaName) AS AreaName,Replace(CustomerSatisfaction,'''','''') As CustomerSatisfaction,count(SurveryFilesId) As Score into #t from vw_SurveyInfoForArea
Where AreaName is not null AND StatusCode=1 AND DeletionStateCode=0 AND AreaDeletionStateCode=0 AND DATEDIFF(MONTH,SurveryMonth,''2008-01-01'')=0 AND DealerId=16 Group By AreaId,Replace(CustomerSatisfaction,'''','''') +
select * from #t '
set @SQL=N'select AreaId,Max(AreaName) AS AreaName,Replace(CustomerSatisfaction,'''','''') As CustomerSatisfaction,count(SurveryFilesId) As Score into #t from vw_SurveyInfoForArea
Where AreaName is not null AND StatusCode=1 AND DeletionStateCode=0 AND AreaDeletionStateCode=0 AND DATEDIFF(MONTH,SurveryMonth,''2008-01-01'')=0 AND DealerId=16 Group By AreaId,Replace(CustomerSatisfaction,'''','''')
select * from #t '
非要把select * from #t 写在里面吗?