34,594
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql VARCHAR(8000)
SELECT * INTO #aaa FROM t1 AS a INNER JOIN t2 AS b ON a.fangshi=b.code
--SELECT * FROM aaa
SET @sql='select id'
SELECT @sql=@sql+',max(case when name='''+name+''' then jine else 0.00 end) as ['+name+']'
FROM (SELECT DISTINCT name FROM t2) AS abc
SET @sql=@sql+' into t3 from #aaa group by id'
PRINT @sql
EXEC (@sql)
DROP TABLE #aaa
select * from t3 --t3就是新创建的表
declare @t nvarchar(10)
declare @sql nvarchar(1000)
set @t='tmp' --要创建表的名
set @sql='create table '+ @t +'(id int,name nvarchar(20))'
exec(@sql)