BOM展开2-白红宇

BOM展开2

阅读量：6272 次

发布时间：2019-06-22

本文共 572 字，大约阅读时间需要 1 分钟。

;WITH BOM (Father,ChildCode,BomQty,iLevel)

( SELECT T0.Code Father,

T1.Code ChildCode,

CAST(T1.Quantity/T0.Qauntity AS DECIMAL(19,4)) BomQty,

1 iLevel

FROM OITT T0

JOIN ITT1 T1 ON T0.Code =T1.Father

UNION ALL

SELECT U0.Father,

T2.Code ,

CAST(U0.BomQty(T2.Quantity/T1.Qauntity) AS DECIMAL(19,4)),
U0.iLevel+1
FROM BOM U0
JOIN OITT T1 ON U0.ChildCode=T1.Code
JOIN ITT1 T2 ON T1.Code =T2.Father
)
SELECT T0.

FROM BOM T0

JOIN OITM T1 ON T0.Father=T1.ItemCode

JOIN OITB T2 ON T2.ItmsGrpCod =T1.ItmsGrpCod

WHERE T2.U_ItemType ='1406'

转载于:https://blog.51cto.com/johnny/2125928

你可能感兴趣的文章

學習 React.js：用 Node 和 React.js 創建一個實時的 Twitter 流

查看>>

solr-4.10.4部署到tomcat6

jdk6.0 + Tomcat6.0的简单jsp,Servlet,javabean的调试

MySQL 索引 BST树、B树、B+树、B*树

第十三章 RememberMe——《跟我学Shiro》