Hi,
Our conservatory came across an old report that they'd like to run again. The only problem is the report comes up blank when you run it. I've done some basic troubleshooting and found that it's joining a local table lt_class_sched to t_perf and tr_season
just for clarity:
into #temp
from lt_class_sched a
join t_perf b on
a.inv_no = b.perf_no
join tr_season c on
b.season = c.id
where b.season = @season
and
b.perf_code = @perf_code
I've done some investigation and found the report is blank because there is no corresponding inv_no in the lt_class_sched. The perf_no does exist in t_perf however.
My question is, how do I find what populates LT_CLASS_SCHED?
I've checked dependencies for the table in SQL and LT_CLASS_SCHED shows no dependencies, though a number of things depend on it.
Any ideas/suggestions are greatly appreciated.
Thanks
Unknown said:I've checked dependencies for the table in SQL and LT_CLASS_SCHED shows no dependencies, though a number of things depend on it.
By the way, the reason I created that procedure was that the dependencies in SQL require that objects be loaded into the database in a specific order, which is largely not the case for either Tessitura tables or custom tables.
Also, I'm pretty sure you won't catch dependencies in triggers or SQL Server Agent jobs.