Finding the source for a LT

Me to – there were a lot of tables created here before my time that here is no documentation for.

Thank you for sharing!

I would be interested in that script, if you wouldn’t mind pasting it in this thread

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
Sent: 18 March, 2016 11:20
To: Robert Martin <rmartin@waltonartscenter.org>
Subject: Re: [Tessitura Technical Forum] Finding the source for a LT

Hi Nick,

I inherited a large web of confusing (and occasionally crazy) custom tables/views/functions/stored procedures, and have gone on to create scores more, so I created a handy stored procedure to do a fairly exhaustive search of database objects for references to other objects.

I can't remember if there's a way to share files through the network site, but you could send me an email address and I could pass it along to you.  Or paste the text of it in here.

--Gawain

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Me to – there were a lot of tables created here before my time that here is no documentation for.

Thank you for sharing!

I would be interested in that script, if you wouldn’t mind pasting it in this thread

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
Sent: 18 March, 2016 11:20
To: Robert Martin <rmartin@waltonartscenter.org>
Subject: Re: [Tessitura Technical Forum] Finding the source for a LT

Hi Nick,

I inherited a large web of confusing (and occasionally crazy) custom tables/views/functions/stored procedures, and have gone on to create scores more, so I created a handy stored procedure to do a fairly exhaustive search of database objects for references to other objects.

I can't remember if there's a way to share files through the network site, but you could send me an email address and I could pass it along to you.  Or paste the text of it in here.

--Gawain

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!