DECLARE @PartsOnly BIT
SET @PartsOnly = 1

DECLARE @AssembliesOnly BIT
SET  @AssembliesOnly = 0

DECLARE @SupressOutput BIT
SET @SupressOutput = 0

DECLARE @StoreResults BIT
SET @StoreResults = 0

;WITH BOM(PartNum, RevisionNum, MtlSeq, MtlPartNum, PartDesc, QtyPer,MfgPartNum, MfgName,Package, Sub, ECO, MaterialCost, ExtendedMaterialCostFormula, TotalCostFormula, ParentPartNum, TopLevelDesc, TopLevelQty, TypeCode) AS (
                   SELECT PartNum,RevisionNum, MtlSeq, MtlPartNum,PartDescription,QtyPer,Character01 AS MfgPartNum,Character04 AS MfgName,Character03 AS Package, Character05 AS Sub, Character07 AS ECO, CASE WHEN (SELECT TypeCode FROM Part WHERE PartNum=v.MtlPartNum)='M' THEN (SELECT dbo.GetBOMCost(v.MtlPartNum)) ELSE (SELECT LastMaterialCost FROM PartCost WHERE PartNum=v.MtlPartNum) END AS MaterialCost, '=PRODUCT(INDIRECT("G" & ROW()),INDIRECT("M" & ROW()))' AS ExtendedMaterialCostFormula, '=PRODUCT(INDIRECT("G" & ROW()),INDIRECT("M" & ROW()))' AS TotalCostFormula, PartNum AS ParentPartNum, TopDescription AS TopLevelDesc, (SELECT QtyPer FROM View_BOM WHERE PartNum=v.PartNum AND MtlPartNum=v.PartNum) AS TopLevelQty, (Select Typecode from Part WHERE PartNum=v.MtlPartNum) AS TypeCode FROM VIEW_BOM AS v WHERE PartNum='66-2672-000'
	               UNION ALL SELECT t2.PartNum, t2.RevisionNum, t2.MtlSeq, t2.MtlPartNum, t2.PartDescription, t2.QtyPer, t2.Character01 AS MfgPartNum, t2.Character04 AS MfgName,t2.Character03 AS Package, t2.Character05 AS Sub, t2.Character07 AS ECO, CASE WHEN (SELECT TypeCode FROM Part WHERE PartNum=t2.MtlPartNum)='M' THEN (SELECT dbo.GetBOMCost(t2.MtlPartNum)) ELSE (SELECT LastMaterialCost FROM PartCost WHERE PartNum=t2.MtlPartNum) END AS MaterialCost, '=PRODUCT(INDIRECT("G" & ROW()),INDIRECT("M" & ROW()))' AS ExtendedMaterialCostFormula, '=PRODUCT(INDIRECT("G" & ROW()),INDIRECT("M" & ROW()))' AS TotalCostFormula, t2.PartNum AS ParentPartNum, t2.TopDescription AS TopLevelDesc, (SELECT QtyPer FROM View_BOM WHERE PartNum=t2.PartNum AND MtlPartNum=t2.PartNum) AS TopLevelQty, t2.TypeCode FROM BOM
                   JOIN View_BOM AS t2
                   ON BOM.MtlPartNum = t2.partnum
                   AND BOM.typecode = 'M'
) SELECT * FROM BOM