TFS Team Foundation Services Installation

 
Not easy. Will not proceed if Frontpage Service Extensions are installed in IIS
In order to remove this go to Tools > Control Panel > Add Remove Programs >Add Remove Window Components > Double-click Application Server > Double-click Internet Information Services IIS > Uncheck Frontpage 2002 Server Extensions
Advertisements

Virtual Server 2005 “Error on Page”

 
Virtual Server 2005 x86 installs on a Virtual Server 2003 machine x64.
In IE8 may get "Error on page" need to enable compatibility view which is the button to the right of the address bar will then work

Recursive CTE – Bill of Materials – BOM View

 
Difficult but got there ! And worth it !
 
/*
Based on a table Product.Products and Product.BillOfMaterials.
*/
 
/*
SELECT * FROM Product.Products WHERE ID = 738
SELECT * FROM Product.vBillOfMaterials WHERE ProductAssemblyID = 738 ORDER BY BOMLevel
SELECT * FROM Product.vBillOfMaterialsName WHERE ProductAssemblyID = 738 ORDER BY BOMLevel
*/
 
CREATE VIEW [Product].[vBillOfMaterials]
 
AS
 
WITH BOM_cte 
AS
(
SELECT b.ProductID AS ProductAssemblyID, ID, ProductID, ComponentID, ItemNo, Quantity, LastUpdate, LastUpdateBy, AlternativeAccy, 0 AS BOMLevel 
FROM Product.BillOfMaterials b
UNION ALL
SELECT cte.ProductAssemblyID, b.ID, b.ProductID, b.ComponentID, b.ItemNo, b.Quantity, b.LastUpdate, b.LastUpdateBy, b.AlternativeAccy, BOMLevel + 1 AS BOMLevel
        FROM [BOM_cte] cte
            INNER JOIN [Product].[BillOfMaterials] b 
            ON b.ProductID = cte.[ComponentID]
)
SELECT BOM.* FROM BOM_cte BOM