Hi Artie,

Haven't had much time to work on this but maybe it'll give you an
idea

DECLARE @current VARCHAR(10)
DECLARE @original VARCHAR(10)

SET @original = 'Washer'
SET @current = @original

WHILE EXISTS (SELECT 1 FROM Hierarchy WHERE Child = @current)
BEGIN
SET @current = (SELECT TOP 1 Parent
FROM Hierarchy
WHERE Child = @current)
PRINT @current
END

DECLARE @count INT
SET @count = 1

WHILE @original <> @current
BEGIN
SET @count = @count * (SELECT qty FROM Hierarchy WHERE Child =
@original)
PRINT @original + ' - ' + CAST(@count AS VARCHAR)
SET @original = (SELECT Parent FROM Hierarchy WHERE Child =
@original)
END

Good luck!
J