Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2007
    Posts
    10

    Unanswered: Internal SQL Server Error

    Server: Msg 8624, Level 16, State 1, Procedure SiteProdRatesCalc, Line 890
    Internal SQL Server error.
    DELETING ANY SITEPRODUCTRATES ENTERED TODAY FOR FC, OT, NT BY SITE GROUP
    CALCULATING RATES FROM ONE RATE SOURCE.


    Line 890 has:
    INSERT INTO #tmpResults (

    We are on SQL Server 2000 SP4 (8.00.2187)....

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    How about posting the whole SQL statement that appears to be causing the problem?
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2007
    Posts
    10
    it is very big SPs... but Line 890 is insert into #tmpresults

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The whole insert statement please
    George
    Home | Blog

  5. #5
    Join Date
    Jul 2007
    Posts
    10
    INSERT INTO #tmpResults ( CountryProductID, ProductCode, ProductTypeCode, BaseBuyRate,
    BuyRateSourceID, BaseSellRate, SellRateSourceID, CalcBestFor,
    CcyBuyRoundFavour, CcyBuyDecPl, TCBuyRoundFavour, TCBuyDecPl,
    TCSellRoundFavour, TCSellDecPl, CcySellRoundFavour, CcySellDecPl,
    CcyBuyVariance, CcyBuyVarianceFrom, TCBuyVariance, TCBuyVarianceFrom,
    TCSellVariance, TCSellVarianceFrom, CcySellVariance, CcySellVarianceFrom)
    SELECT DISTINCT RSR.CountryProductID, CP.ProductID, CP.ProductTypeID, RSR.BuyRate,
    RSR.RateSourceID, RSR.SellRate, RSR.RateSourceID, CPR.CalcBestFor,
    CPR.CcyBuyRoundFavour, CPRO.DecimalPlaces, CPR.TCBuyRoundFavour, CPRO.DecimalPlaces,
    CPR.TCSellRoundFavour, CPRO.DecimalPlaces, CPR.CcySellRoundFavour, CPRO.DecimalPlaces,
    CPRO.CcyBuyVariance, CPR.CcyBuyVarianceFrom, CPRO.TCBuyVariance, CPR.TCBuyVarianceFrom,
    CPRO.TCSellVariance, CPR.TCSellVarianceFrom, CPRO.CcySellVariance, CPR.CcySellVarianceFrom
    FROM CherryPickRuleSets AS CPR
    INNER JOIN CherryPickRateSources AS CPRS
    ON CPRS.CherryPickRuleSetID = CPR.CherryPickRuleSetID
    INNER JOIN RateSourceRates AS RSR
    ON CPRS.RateSourceID = RSR.RateSourceID
    INNER JOIN CountryProducts AS CP
    ON RSR.CountryProductID = CP.CountryProductID
    INNER JOIN CherryPickRateOrder AS CPRO
    ON CPRO.CherryPickRuleSetID = CPR.CherryPickRuleSetID
    AND CP.productid = CPRO.ProductCode
    WHERE CP.ProductTypeID = 'FC'
    AND CPR.CherryPickRuleSetID = @CherryPickID
    AND RSR.DateEntered = @TheDate

  6. #6
    Join Date
    Jul 2007
    Posts
    10
    I hope this is what you needed right george....

  7. #7
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by hdshah
    INSERT INTO #tmpResults ( CountryProductID, ProductCode, ProductTypeCode, BaseBuyRate,
    BuyRateSourceID, BaseSellRate, SellRateSourceID, CalcBestFor,
    CcyBuyRoundFavour, CcyBuyDecPl, TCBuyRoundFavour, TCBuyDecPl,
    TCSellRoundFavour, TCSellDecPl, CcySellRoundFavour, CcySellDecPl,
    CcyBuyVariance, CcyBuyVarianceFrom, TCBuyVariance, TCBuyVarianceFrom,
    TCSellVariance, TCSellVarianceFrom, CcySellVariance, CcySellVarianceFrom)
    SELECT DISTINCT RSR.CountryProductID, CP.ProductID, CP.ProductTypeID, RSR.BuyRate,
    RSR.RateSourceID, RSR.SellRate, RSR.RateSourceID, CPR.CalcBestFor,
    CPR.CcyBuyRoundFavour, CPRO.DecimalPlaces, CPR.TCBuyRoundFavour, CPRO.DecimalPlaces,
    CPR.TCSellRoundFavour, CPRO.DecimalPlaces, CPR.CcySellRoundFavour, CPRO.DecimalPlaces,
    CPRO.CcyBuyVariance, CPR.CcyBuyVarianceFrom, CPRO.TCBuyVariance, CPR.TCBuyVarianceFrom,
    CPRO.TCSellVariance, CPR.TCSellVarianceFrom, CPRO.CcySellVariance, CPR.CcySellVarianceFrom
    FROM CherryPickRuleSets AS CPR
    INNER JOIN CherryPickRateSources AS CPRS
    ON CPRS.CherryPickRuleSetID = CPR.CherryPickRuleSetID
    INNER JOIN RateSourceRates AS RSR
    ON CPRS.RateSourceID = RSR.RateSourceID
    INNER JOIN CountryProducts AS CP
    ON RSR.CountryProductID = CP.CountryProductID
    INNER JOIN CherryPickRateOrder AS CPRO
    ON CPRO.CherryPickRuleSetID = CPR.CherryPickRuleSetID
    AND CP.productid = CPRO.ProductCode
    WHERE CP.ProductTypeID = 'FC'
    AND CPR.CherryPickRuleSetID = @CherryPickID
    AND RSR.DateEntered = @TheDate
    I assume there is a create table statement associated with this somewhere, unless a select into was done previous.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •