--创建、删除临时表
--第一种方式
create table #tmp(name varchar(255),id int)
--第二种方式
select count(id) as storyNum ,
sum(convert(numeric(10,2),case when isnumeric(code)=1 then code else 0 end)) as codeNum,
sum((case when isnumeric(realcode)=1 then convert(numeric(10,2),realcode) else 0.0 end)) as realcodeNum,
tdtname,cycle,jiracomponent,jirastatename,qualityvalue,storycodellt
into #tmp from IKNOW_STORY_U2000V1R7C00 group by tdtname,cycle,jiracomponent,jirastatename,qualityvalue,storycodellt
--查询临时表
select * from #tmp
--删除临时表
if object_id('tempdb..#tmp') is not null
begin
drop table #tmp
end