January 30, 2008 at 1:03 pm
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.
For example
fld table data:
ID Calc_name
12219 AT_BookValue
9952 AT_BookValue1
16 UPriceFactorHLD
23 QtyUnitsL/S HLD
8213 HLD_BookVal2
fld_term (This table stores actual calculation and if that calc callc any other calc)
ID u
12219 9952
9952 23
9952 16
23 15
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....
Thanks,
Anu.
January 31, 2008 at 5:29 am
You should post this question in the 2000 forum because you may start getting 2005 solutions to the problem that will not work in 2000. For example, I think I could make this work with a Common Table Expression, but you won't be able to run that in your SQL Server 2000 system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply