Thanks for the solution, I have upto 100 int values depending on the options selected, so the Function iter_intlist_to_table works fine and is now up and running.

Solution copied from...

I've had a search and found this article which creates the hierarchy in a sql statements - brill

http://www.sqlteam.com/item.asp?ItemID=8866

Thanks for help

Graham

The code I'm using to navigate the tree is below:

However, when I run this, one iteration affects the others.

CREATE PROCEDURE dbo.sp_Load_CostCode

 @PrevCostObj_ID int

AS

DECLARE

-- Cursor Fields

@CostObj_ID int

BEGIN

set nocount on

DECLARE curLevel CURSOR...