Hi Jeff,

I've fixed the problem with the CROSS JOIN, it looks like we've had that code in there for a good few years:rolleyes:.

Here's the revised code: -

SELECT

f1.ComponentNo

,f1.SubFormAnalyID

,f1.FeatureAnalyID

,f1.RepeatNo

,f1.SimulationNo

,f1.IsVarParam

,f1.LibItemID

,f1.LibVerNo

,f1.IntValue

,f1.RealValue

,f1.TextValue

,pc.CompAnalyID

,ft.EnumTypeID

,<<@ParentNo>>

FROM dbo.<<@NW_Feature>> AS f1

JOIN dbo.<<@NW_Component>> AS nc ON f1.ComponentNo = nc.ComponentNo

JOIN dbo.PCC_Component AS pc ON nc.PhysID = pc.PhysID

JOIN dbo.Feature AS ft ON f1.FeatureAnalyID = ft.AnalyID

WHERE f1.SimulationNo <= ( SELECT MAX(SimulationNo)

FROM <<@NW_Feature>> AS nwf1

WHERE f1.ComponentNo = nwf1.ComponentNo

AND f1.SubFormAnalyID = nwf1.SubFormAnalyID

AND f1.FeatureAnalyID = nwf1.FeatureAnalyID

AND f1.RepeatNo = nwf1.RepeatNo

)

AND ft.EnumTypeID NOT IN (14,15)

;

Thanks,

Darren