Sql Server 判断临时表是否存在，存在则删除，临时表一定要加"tempdb.. "
if OBJECT_ID(N'tempdb..#temp',N'U') is not null
DROP TABLE #temp;--项目时表
if OBJECT_ID(N'tempdb..#temp',N'U') is not null
DROP TABLE #temp;--检验子项目临时表
--查询检验完成时间最大的检验子项目
select
MAX(FINISHDATE) FINISHDATE
,testname
,analystname
,sapmkmnr
,Custom_SampleInspectionResult_ID
,ID
into #temp
from Custom_SampleInspectionResultDetails
group by Custom_SampleInspectionResult_ID
,testname
,analystname
,sapmkmnr
,Custom_SampleInspectionResult_ID
,ID