• Replies 18 replies
  • Subscribers 336 subscribers
  • Views 42 views
  • Users 0 members are here
Related

Finding the source for a LT

Former Member
Former Member $organization

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

Parents
  • Former Member
    Former Member $organization
    scripting the table gives me the table creation SQL:

    USE [impresario]
    GO

    /****** Object:  Table [dbo].[LT_CLASS_SCHED]    Script Date: 03/18/2016 12:29:08 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE [dbo].[LT_CLASS_SCHED](
    [id_key] [int] NOT NULL,
    [inv_no] [int] NOT NULL,
    [class_title] [nvarchar](30) NULL,
    [teacher_name] [nvarchar](50) NULL,
    [Monday] [char](1) NULL,
    [Tuesday] [char](1) NULL,
    [Wednesday] [char](1) NULL,
    [Thursday] [char](1) NULL,
    [Saturday] [char](1) NULL,
    [Sunday] [char](1) NULL,
    [montime] [nchar](12) NULL,
    [tuetime] [nchar](12) NULL,
    [wedtime] [nchar](12) NULL,
    [thurtime] [nchar](12) NULL,
    [sattime] [nchar](12) NULL,
    [suntime] [nchar](12) NULL,
     CONSTRAINT [PK_LT_CLASS_SCHED] PRIMARY KEY CLUSTERED 
    (
    [id_key] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO

    But how are new inv_no added?


    On Fri, Mar 18, 2016 at 12:28 PM, Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> wrote:
    To find the logic right click on the table and do a Script As Create to a new query





    On Fri, Mar 18, 2016 at 8:58 AM -0700, "Nick Torres" <bounce-nicktorres3067@tessituranetwork.com<mailto:bounce-nicktorres3067@tessituranetwork.com>> wrote:


    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!

Reply
  • Former Member
    Former Member $organization
    scripting the table gives me the table creation SQL:

    USE [impresario]
    GO

    /****** Object:  Table [dbo].[LT_CLASS_SCHED]    Script Date: 03/18/2016 12:29:08 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE [dbo].[LT_CLASS_SCHED](
    [id_key] [int] NOT NULL,
    [inv_no] [int] NOT NULL,
    [class_title] [nvarchar](30) NULL,
    [teacher_name] [nvarchar](50) NULL,
    [Monday] [char](1) NULL,
    [Tuesday] [char](1) NULL,
    [Wednesday] [char](1) NULL,
    [Thursday] [char](1) NULL,
    [Saturday] [char](1) NULL,
    [Sunday] [char](1) NULL,
    [montime] [nchar](12) NULL,
    [tuetime] [nchar](12) NULL,
    [wedtime] [nchar](12) NULL,
    [thurtime] [nchar](12) NULL,
    [sattime] [nchar](12) NULL,
    [suntime] [nchar](12) NULL,
     CONSTRAINT [PK_LT_CLASS_SCHED] PRIMARY KEY CLUSTERED 
    (
    [id_key] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO

    But how are new inv_no added?


    On Fri, Mar 18, 2016 at 12:28 PM, Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> wrote:
    To find the logic right click on the table and do a Script As Create to a new query





    On Fri, Mar 18, 2016 at 8:58 AM -0700, "Nick Torres" <bounce-nicktorres3067@tessituranetwork.com<mailto:bounce-nicktorres3067@tessituranetwork.com>> wrote:


    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!

Children
No Data