Post reply

Error 208: Invalid object name 'gg'

  • June 16, 2009 at 1:15 am

    #103762

    Hi Guys,

    when I run this below storeProcedure am getting 'Invalid object name 'gg' error,

    thing is query executes successfully later I get this error msg,

    can anyone help me out how to handle this error,

    WITH gg(FinancialYear,Account,SumaDeDebe,SumaDeHaber,SumaDeCDebe,SumaDeCHaber)AS

    (

    SELECT MFBCXPFO.dbo.Journal.FinancialYear, MFBCXPFO.dbo.Journal.Account,SUM(Debit) AS SumaDeDebe, SUM(Credit) AS SumaDeHaber,

    SUM(CDebit) AS SumaDeCDebe, SUM(CCredit) AS SumaDeCHaber

    FROM MFBCXPFO.dbo.Journal INNER JOIN MFBCXPFO.dbo.accountingplan ON MFBCXPFO.dbo.Journal.financialyear = MFBCXPFO.dbo.accountingplan.financialyear AND MFBCXPFO.dbo.Journal.account= MFBCXPFO.dbo.accountingplan.account

    WHERE MFBCXPFO.dbo.Journal.FinancialYear = 2000 AND MFBCXPFO.dbo.Journal.Entry = 0

    GROUP BY MFBCXPFO.dbo.Journal.FinancialYear, MFBCXPFO.dbo.Journal.Account, MFBCXPFO.dbo.Journal. Period

    )

    SELECT FinancialYear,Account,SumaDeDebe,SumaDeHaber,SumaDeCDebe,SumaDeCHaber FROM gg

    UPDATE Balance SET Balance.FinancialYear=gg.FinancialYear, Balance.Account=gg.Account,Debit0=gg.Sumadedebe, Debit1 =gg.Sumadedebe,

    Debit2 =gg.Sumadedebe, Debit3=gg.Sumadedebe, Debit4 =gg.Sumadedebe, Debit5 =gg.Sumadedebe, Debit6=gg.Sumadedebe,

    Debit7 =gg.Sumadedebe , Debit8 =gg.Sumadedebe , Debit9=gg.Sumadedebe , Debit10 =gg.Sumadedebe ,

    Debit11 =gg.Sumadedebe , Debit12=gg.Sumadedebe , Debit13=gg.Sumadedebe , Credit0 =gg.sumadehaber ,

    Credit1 =gg.sumadehaber , Credit2=gg.sumadehaber , Credit3=gg.sumadehaber , Credit4 =gg.sumadehaber ,

    Credit5 =gg.sumadehaber , Credit6 =gg.sumadehaber , Credit7 =gg.sumadehaber , Credit8 =gg.sumadehaber ,

    Credit9 =gg.sumadehaber , Credit10 =gg.sumadehaber , Credit11 =gg.sumadehaber , Credit12=gg.sumadehaber ,

    Credit13 =gg.sumadehaber , Debit =gg.Sumadedebe , Credit =gg.sumadehaber , Balance =(gg.Sumadedebe-gg.sumadehaber),

    CDebit0 =gg.sumadecDebe , CDebit1 =gg.sumadecDebe , CDebit2=gg.sumadecDebe , CDebit3 =gg.sumadecDebe ,

    CDebit4=gg.sumadecDebe , CDebit5 =gg.sumadecDebe , CDebit6 =gg.sumadecDebe , CDebit7=gg.sumadecDebe ,

    CDebit8 =gg.sumadecDebe , CDebit9=gg.sumadecDebe , CDebit10 =gg.sumadecDebe , CDebit11 =gg.sumadecDebe ,

    CDebit12 =gg.sumadecDebe , CDebit13=gg.sumadecDebe ,

    CCredit0 =gg.sumadechaber , CCredit1 =gg.sumadechaber , CCredit2=gg.sumadechaber , CCredit3 =gg.sumadechaber ,

    CCredit4 =gg.sumadechaber , CCredit5 =gg.sumadechaber , CCredit6 =gg.sumadechaber , CCredit7 =gg.sumadechaber ,

    CCredit8 =gg.sumadechaber , CCredit9 =gg.sumadechaber , CCredit10 =gg.sumadechaber , CCredit11 =gg.sumadechaber ,

    CCredit12 =gg.sumadechaber , CCredit13=gg.sumadechaber, CDebit=gg.sumadecDebe, CCredit=gg.sumadechaber,

    CBalance=(gg.sumadecDebe-gg.sumadechaber) where FinancialYear=(select FinancialYear from gg) AND Account=(select FinancialYear from gg)

  • June 16, 2009 at 2:31 am

    #1010065

    1. check if the table gg exists

    2. check the owner name, you might need to write like this

    owner.gg


    Pradeep Singh

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply