数据表 [JC48a] 有1.6亿条数据，表WMNumber 有80条数据 ，原来可以执行下面的脚本得到临时表，但再次执行这段脚本时 SQL SERVER报错
->消息 8623，级别 16，状态 1，第 7 行
查询处理器用尽了内部资源，无法生成查询计划。这种情况很少出现，只有在查询极其复杂或引用了大量表或分区时才会出现。请简化查询。如果您认为该消息的出现纯属错误，请与客户支持服务部门联系，了解详细信息。
if object_id('[tempdb]..#test') is not null drop table #test
go
Select ID,(
(Select top 1 WValue From WMNumber Where m1=seq)
+ (Select top 1 WValue From WMNumber Where m2=seq)
+ (Select top 1 WValue From WMNumber Where m3=seq)
+ (Select top 1 WValue From WMNumber Where m4=seq)
+ (Select top 1 WValue From WMNumber Where m5=seq)
+ (Select top 1 WValue From WMNumber Where m6=seq)
+ (Select top 1 WValue From WMNumber Where m7=seq)
+ (Select top 1 WValue From WMNumber Where m8=seq)
+ (Select top 1 WValue From WMNumber Where m9=seq)
+ (Select top 1 WValue From WMNumber Where m10=seq)
+ (Select top 1 WValue From WMNumber Where m11=seq)
+ (Select top 1 WValue From WMNumber Where m12=seq)
+ (Select top 1 WValue From WMNumber Where m13=seq)
+ (Select top 1 WValue From WMNumber Where m14=seq)
+ (Select top 1 WValue From WMNumber Where m15=seq)
+ (Select top 1 WValue From WMNumber Where m16=seq)
+ (Select top 1 WValue From WMNumber Where m17=seq)
+ (Select top 1 WValue From WMNumber Where m18=seq)
+ (Select top 1 WValue From WMNumber Where m19=seq)
+ (Select top 1 WValue From WMNumber Where m20=seq)
) as WSum Into #test
FROM [JC48a]
Where 1=1
and m1 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m2 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m3 in(Select seq From WMNumber WHere WValue Between 1 and 8)
and m4 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m5 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m6 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m7 in(Select seq From WMNumber WHere WValue Between 2 and 18)
and m8 in(Select seq From WMNumber WHere WValue Between 1 and 4)
and m9 in(Select seq From WMNumber WHere WValue Between 1 and 8)
and m10 in(Select seq From WMNumber WHere WValue Between 1 and 1)
and m11 in(Select seq From WMNumber WHere WValue Between 1 and 1)
and m12 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m13 in(Select seq From WMNumber WHere WValue Between 1 and 1)
and m14 in(Select seq From WMNumber WHere WValue Between 1 and 1)
and m15 in(Select seq From WMNumber WHere WValue Between 3 and 18)
and m16 in(Select seq From WMNumber WHere WValue Between 2 and 18)
and m17 in(Select seq From WMNumber WHere WValue Between 1 and 9)
and m18 in(Select seq From WMNumber WHere WValue Between 1 and 19)
and m19 in(Select seq From WMNumber WHere WValue Between 1 and 18)
and m20 in(Select seq From WMNumber WHere WValue Between 1 and 6)
