22,210
社区成员
发帖
与我相关
我的任务
分享
if @IncludeSub = '1'
begin
if object_id('tempdb..#tmpDim') > 0 drop table #tmpDim
select distinct DimCode
into #tmpDim
from dbo.DSS_TargetDim TD
inner join dbo.DSS_Target T on T.[Target] = TD.[Target]
where CanAuthorize = 1
and ( T.[Target] in (select [Target] from #tmpTarget)
or
T.ParentTarget in (select [Target] from tmpTarget)
)
end
else
begin
if object_id('tempdb..#tmpDim') > 0 drop table #tmpDim
select distinct DimCode
into #tmpDim
from dbo.DSS_TargetDim TD
inner join dbo.DSS_Target T on T.[Target] = TD.[Target]
where CanAuthorize = 1
and T.[Target] in (select [Target] from tmpTarget)
end
if @IncludeSub = '1'
begin
if object_id('tempdb..#tmpDim') > 0 drop table #tmpDim
GO
select distinct DimCode
into #tmpDim
from dbo.DSS_TargetDim TD
inner join dbo.DSS_Target T on T.[Target] = TD.[Target]
where CanAuthorize = 1
and ( T.[Target] in (select [Target] from #tmpTarget)
or
T.ParentTarget in (select [Target] from tmpTarget)
)
end
else
begin
if object_id('tempdb..#tmpDim') > 0 drop table #tmpDim
go
select distinct DimCode
into #tmpDim
from dbo.DSS_TargetDim TD
inner join dbo.DSS_Target T on T.[Target] = TD.[Target]
where CanAuthorize = 1
and T.[Target] in (select [Target] from tmpTarget)
end
测试时可以的,应该是其他地方问题
if object_id('tempdb..#tmpDim') > 0 drop table #tmpDim
go
select * into #tmpDim from tb
select * from #tmpDim
name code1 code2 code3
---------- ----------- ----------- -----------
张三 1 6 NULL
李四 2 7 2066
里斯本 3 8 2052
昌盛 4 9 NULL
蝇头 5 10 2051
(5 行受影响)