DECLARE @s nvarchar(4000)
SET @s = N''SELECT @s = @s
+ N',' + QUOTENAME(xjdd) + N'= SUM(CASE xjdd WHEN N'
+ QUOTENAME(xjdd, N'''') + N' THEN yxcs ELSE 0 END)'
FROM(
SELECT DISTINCT xjdd FROM AQ_DDXCPL
)A
EXEC(N'
SELECT xjld '+ @s + N'
FROM AQ_DDXCPL
GROUP BY xjld')
=========================================分割线============================
DECLARE @s nvarchar(4000)
SET @s = N''SELECT @s = @s
+ N',' + QUOTENAME(xjdd) + N'= SUM(CASE xjdd WHEN N'
+ QUOTENAME(xjdd, N'''') + N' THEN yxcs ELSE 0 END)'
FROM(
SELECT DISTINCT xjdd FROM AQ_DDXCPL
)A
EXEC(N'
SELECT xjld '+ @s + N'
into #a FROM AQ_DDXCPL -------插入临时表
GROUP BY xjld')select * from #a --- 错误
drop table #a
SET @s = N''SELECT @s = @s
+ N',' + QUOTENAME(xjdd) + N'= SUM(CASE xjdd WHEN N'
+ QUOTENAME(xjdd, N'''') + N' THEN yxcs ELSE 0 END)'
FROM(
SELECT DISTINCT xjdd FROM AQ_DDXCPL
)A
EXEC(N'
SELECT xjld '+ @s + N'
FROM AQ_DDXCPL
GROUP BY xjld')
=========================================分割线============================
DECLARE @s nvarchar(4000)
SET @s = N''SELECT @s = @s
+ N',' + QUOTENAME(xjdd) + N'= SUM(CASE xjdd WHEN N'
+ QUOTENAME(xjdd, N'''') + N' THEN yxcs ELSE 0 END)'
FROM(
SELECT DISTINCT xjdd FROM AQ_DDXCPL
)A
EXEC(N'
SELECT xjld '+ @s + N'
into #a FROM AQ_DDXCPL -------插入临时表
GROUP BY xjld')select * from #a --- 错误
drop table #a
解决方案 »
- SELECT IN 的问题
- mysql查询问题
- runtime error的问题
- 请帮我介绍几本ms sql的经典
- 如何用SQL把varchar型的转化成datetime型的?(没你想的那么简单)
- Java 通过 JDBC 分别在混合验证模式和 Windows 身份验证模式下连接 SQL Server 2008 或 2005 的连接实例
- 关于 dts 的应用
- 我想要一个包含internet已注册域名的数据库,并请教您一个sql的语句!
- 如何在vb中获取sql server产生的序列号值?
- 根据sql server本身功能,如何知晓当前数据库连接用户的IP地址
- 我把administrator开机密码改了,sql服务器打不开了,怎么办
- 请教从交叉表生成一张新表的语句该怎么写?
SET @s = N''SELECT @s = @s
+ N',' + QUOTENAME(xjdd) + N'= SUM(CASE xjdd WHEN N'
+ QUOTENAME(xjdd, N'''') + N' THEN yxcs ELSE 0 END)'
FROM(
SELECT DISTINCT xjdd FROM AQ_DDXCPL
)A
EXEC(N'
SELECT xjld '+ @s + N'
into ##a FROM AQ_DDXCPL -------插入临时表
GROUP BY xjld')select * from ##a
drop table ##a
SELECT xjld '+ @s + N'
into #a FROM AQ_DDXCPL -------插入临时表
GROUP BY xjld')
select * from #a --- 错误
drop table #a
---------------------------------------------------------------------------------
把#a改成##a,即将局部临时表换成全局临时表。