I need to write a stored procedure in SQL 2000.
I have a tables fld and fld_term, relashionship is fld.id = fld_term.id
fld is a calculation name table and fld_term is a the actual calculation table. A calculation can call other calculation and so forth.
fld table data:
23 QtyUnitsL/S HLD
fld_term (This table stores actual calculation and if that calc callc any other calc)
So what i want is if i pass AT_BookValue to my stored procedure it should bring all the calcs that are referenced inside
12219 is referencing 9952, 16, 23, 15....