

From Work Packages to ERP/MRP/PDM/PLM
Americas ShipConstructor User Conference 2014


-Archimedes
"Give me a lever long enough
Americas ShipConstructor User Conference 2014
and a fulcrum on which to place it,
and I shall move the world."


Americas ShipConstructor User Conference 2014


Americas ShipConstructor User Conference 2014

Americas ShipConstructor User Conference 2014

Americas ShipConstructor User Conference 2014


Americas ShipConstructor User Conference 2014


Americas ShipConstructor User Conference 2014



Americas ShipConstructor User Conference 2014


Americas ShipConstructor User Conference 2014
FROM dbo.GEN_tblAssemblies AS Assemblies2 INNER JOIN
dbo.GEN_tblRanks AS r ON Assemblies2.RankGUID = r.RankGUID INNER JOIN
dbo.GEN_tblBuildStrategies AS bs ON r.BuildStrategyGUID = bs.BuildStrategyGUID LEFT OUTER JOIN
dbo.GEN_tblAssemblies AS B ON B.LeftValue =
(SELECT MAX(LeftValue) AS Expr1
FROM dbo.GEN_tblAssemblies AS S
WHERE (Assemblies2.LeftValue > LeftValue) AND (Assemblies2.LeftValue < RightValue)) LEFT OUTER JOIN
dbo.GEN_tblAssemblies AS Assemblies1 ON Assemblies1.LeftValue BETWEEN Assemblies2.LeftValue AND Assemblies2.RightValue LEFT OUTER JOIN


Americas ShipConstructor User Conference 2014



Americas ShipConstructor User Conference 2014

Americas ShipConstructor User Conference 2014



Americas ShipConstructor User Conference 2014

Americas ShipConstructor User Conference 2014

Americas ShipConstructor User Conference 2014

Patrick.David
@ssi-corporate.com
