Below is an update to some functions:

CREATE FUNCTION dbo.udf_HandlingEquip (@ItemTypeID int) 

RETURNS TABLE AS

RETURN

(SELECT vwItemTypes.*, ItemTypeUses.ItemTypeUseID, ItemTypeUses.ItemTypeUse

FROM    ItemTypeItemTypes INNER JOIN

       ...

Here it is:

--Tables

CREATE TABLE [dbo].[AssetItemTypes] (

 [AssetItemTypeID] [int] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[BaseItems_Systems] (

 [SystemBaseItemID] [int] IDENTITY (1, 1) NOT NULL ,

 [SystemID] [int] NOT NULL , [BaseItemID] [int] NOT NULL ,

 [BaseItemUseID]...

Folks,

The DDL alone is over 400 lines. Is that too many to post?

Frank,

I have a database that represents the relationship between Items in a parent-child hierarchy form. In the parent-child relationships there are Systems at the top and several layers of SubItems...

Thanks Mike.