22,209
社区成员
发帖
与我相关
我的任务
分享
-- 字段列表你可以拼的嘛
DECLARE @sql VARCHAR(8000),
@cols varchar(80000;
SET @sql = 'SELECT Opearcode'
SET @cols = ''
SELECT @sql = @sql + ',SUM(CASE breedCode WHEN ''' + BreedCode + ''' THEN total END) [' + BreedCode + ']' ,
@cols = @cols + ',[' + BreedCode + ']'
FROM (SELECT DISTINCT BreedCode FROM #tmpTable) AS C
SELECT @sql = @sql + 'from #tmpTable group by oprcode'
SELECT @cols = STUFF(@cols, 1, 1, '')
EXEC( '
INSERT 表一(' + @cols + ') ' + @sql)
insert tb1(col,col2...)select col,col2... from tb2 --注意字段對應類型一致