AW: Fehler bei Datenbankimport
Hallo,
hier der Fehlerlog:
Unbehandelte Ausnahme #222ED449F8AEDFC9 vom Typ System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Objektname 'tBestellStueckliste'.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei jtlDatabase.DB.jKgpwmFbh5[T](SqlConnection , Func`1 func)
bei jtlDatabase.DB.executeLongRunningCommandSQL(String cSqlCommand)
bei jtlCore.Classes.Update.SqlUpdater.<>c__DisplayClass2.<UpdateToVersion>b__0()
bei jtlCore.Classes.Update.SqlUpdater.IqRGkCtDSferdjgc80.EIxNJvSgMh(Action , Int32 , String )
bei jtlCore.Classes.Update.SqlUpdater.GQeamKjJy0(IList`1 sqlCommands, String , TaskProgress )
ClientConnectionId:65dcd0ce-2ded-4213-b0be-4d640317db55
SQL-Fehlerinformationen: [VMWAWI\JTLWAWI .Net SqlClient Data Provider] Fehler #208 (Klasse 16) in Zeile 169: Ungültiger Objektname 'tBestellStueckliste'. spReservierungAktualisieren
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 11.00.2100
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 208
HelpLink.BaseHelpUrl =
Microsoft Deutschland | Geräte und Dienste
HelpLink.LinkId = 20476
CommandText = ---
--- BIGINT auf INT als Datentyp umstellen. Vorher mögliche Werte die außerhalb des Decimalbereiches liegen anpassen.
---
UPDATE dbo.ebay_alienitem SET VATPercent = CASE WHEN VATPercent < 0 THEN -1E+12 ELSE 1E+12 END WHERE VATPercent IS NOT NULL AND (VATPercent > 1E+12 OR VATPercent < -1E+12 )
UPDATE dbo.ebay_bestoffer SET CounterPrice = CASE WHEN CounterPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE CounterPrice IS NOT NULL AND (CounterPrice > 1E+12 OR CounterPrice < -1E+12 )
UPDATE dbo.ebay_bestoffer SET Price = CASE WHEN Price < 0 THEN -1E+12 ELSE 1E+12 END WHERE Price IS NOT NULL AND (Price > 1E+12 OR Price < -1E+12 )
UPDATE dbo.ebay_buyer SET PositiveFeedbackPercent = CASE WHEN PositiveFeedbackPercent < 0 THEN -1E+12 ELSE 1E+12 END WHERE PositiveFeedbackPercent IS NOT NULL AND (PositiveFeedbackPercent > 1E+12 OR PositiveFeedbackPercent < -1E+12 )
UPDATE dbo.ebay_checkoutpos SET fAnzahl = CASE WHEN fAnzahl < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAnzahl IS NOT NULL AND (fAnzahl > 1E+12 OR fAnzahl < -1E+12 )
UPDATE dbo.ebay_coposeigenschaft SET fAufpreis = CASE WHEN fAufpreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAufpreis IS NOT NULL AND (fAufpreis > 1E+12 OR fAufpreis < -1E+12 )
UPDATE dbo.ebay_de_geb_angebotsgebuehr SET Gebuehr = CASE WHEN Gebuehr < 0 THEN -1E+12 ELSE 1E+12 END WHERE Gebuehr IS NOT NULL AND (Gebuehr > 1E+12 OR Gebuehr < -1E+12 )
UPDATE dbo.ebay_de_geb_angebotsgebuehr SET PreisMax = CASE WHEN PreisMax < 0 THEN -1E+12 ELSE 1E+12 END WHERE PreisMax IS NOT NULL AND (PreisMax > 1E+12 OR PreisMax < -1E+12 )
UPDATE dbo.ebay_de_geb_angebotsgebuehr SET PreisMin = CASE WHEN PreisMin < 0 THEN -1E+12 ELSE 1E+12 END WHERE PreisMin IS NOT NULL AND (PreisMin > 1E+12 OR PreisMin < -1E+12 )
UPDATE dbo.ebay_de_geb_angebotsgebuehrausnahmen SET Gebuehr = CASE WHEN Gebuehr < 0 THEN -1E+12 ELSE 1E+12 END WHERE Gebuehr IS NOT NULL AND (Gebuehr > 1E+12 OR Gebuehr < -1E+12 )
UPDATE dbo.ebay_de_geb_erweiterungen SET Gebuehr = CASE WHEN Gebuehr < 0 THEN -1E+12 ELSE 1E+12 END WHERE Gebuehr IS NOT NULL AND (Gebuehr > 1E+12 OR Gebuehr < -1E+12 )
UPDATE dbo.ebay_de_validationrules SET fMax = CASE WHEN fMax < 0 THEN -1E+12 ELSE 1E+12 END WHERE fMax IS NOT NULL AND (fMax > 1E+12 OR fMax < -1E+12 )
UPDATE dbo.ebay_de_validationrules SET fMin = CASE WHEN fMin < 0 THEN -1E+12 ELSE 1E+12 END WHERE fMin IS NOT NULL AND (fMin > 1E+12 OR fMin < -1E+12 )
UPDATE dbo.ebay_InternationalShippingServiceOption SET ShippingServiceAdditionalCost = CASE WHEN ShippingServiceAdditionalCost < 0 THEN -1E+12 ELSE 1E+12 END WHERE ShippingServiceAdditionalCost IS NOT NULL AND (ShippingServiceAdditionalCost > 1E+12 OR ShippingServiceAdditionalCost < -1E+12 )
UPDATE dbo.ebay_InternationalShippingServiceOption SET ShippingServiceCost = CASE WHEN ShippingServiceCost < 0 THEN -1E+12 ELSE 1E+12 END WHERE ShippingServiceCost IS NOT NULL AND (ShippingServiceCost > 1E+12 OR ShippingServiceCost < -1E+12 )
UPDATE dbo.ebay_item SET BestOfferAutoAcceptPrice = CASE WHEN BestOfferAutoAcceptPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE BestOfferAutoAcceptPrice IS NOT NULL AND (BestOfferAutoAcceptPrice > 1E+12 OR BestOfferAutoAcceptPrice < -1E+12 )
UPDATE dbo.ebay_item SET BestOfferMinPrice = CASE WHEN BestOfferMinPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE BestOfferMinPrice IS NOT NULL AND (BestOfferMinPrice > 1E+12 OR BestOfferMinPrice < -1E+12 )
UPDATE dbo.ebay_item SET fGewicht = CASE WHEN fGewicht < 0 THEN -1E+12 ELSE 1E+12 END WHERE fGewicht IS NOT NULL AND (fGewicht > 1E+12 OR fGewicht < -1E+12 )
UPDATE dbo.ebay_item SET Totalfees = CASE WHEN Totalfees < 0 THEN -1E+12 ELSE 1E+12 END WHERE Totalfees IS NOT NULL AND (Totalfees > 1E+12 OR Totalfees < -1E+12 )
UPDATE dbo.ebay_item SET VATPercent = CASE WHEN VATPercent < 0 THEN -1E+12 ELSE 1E+12 END WHERE VATPercent IS NOT NULL AND (VATPercent > 1E+12 OR VATPercent < -1E+12 )
UPDATE dbo.ebay_item2kombi SET fAnzahl = CASE WHEN fAnzahl < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAnzahl IS NOT NULL AND (fAnzahl > 1E+12 OR fAnzahl < -1E+12 )
UPDATE dbo.ebay_item2kombi SET fMaxAnzahl = CASE WHEN fMaxAnzahl < 0 THEN -1E+12 ELSE 1E+12 END WHERE fMaxAnzahl IS NOT NULL AND (fMaxAnzahl > 1E+12 OR fMaxAnzahl < -1E+12 )
UPDATE dbo.ebay_item2kombi SET fPreis = CASE WHEN fPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreis IS NOT NULL AND (fPreis > 1E+12 OR fPreis < -1E+12 )
UPDATE dbo.ebay_mapitem SET CurrentPrice = CASE WHEN CurrentPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE CurrentPrice IS NOT NULL AND (CurrentPrice > 1E+12 OR CurrentPrice < -1E+12 )
UPDATE dbo.ebay_ShippingServiceOptions SET ShippingServiceAdditionalCost = CASE WHEN ShippingServiceAdditionalCost < 0 THEN -1E+12 ELSE 1E+12 END WHERE ShippingServiceAdditionalCost IS NOT NULL AND (ShippingServiceAdditionalCost > 1E+12 OR ShippingServiceAdditionalCost < -1E+12 )
UPDATE dbo.ebay_ShippingServiceOptions SET ShippingServiceCost = CASE WHEN ShippingServiceCost < 0 THEN -1E+12 ELSE 1E+12 END WHERE ShippingServiceCost IS NOT NULL AND (ShippingServiceCost > 1E+12 OR ShippingServiceCost < -1E+12 )
UPDATE dbo.ebay_transaction SET VAT = CASE WHEN VAT < 0 THEN -1E+12 ELSE 1E+12 END WHERE VAT IS NOT NULL AND (VAT > 1E+12 OR VAT < -1E+12 )
UPDATE dbo.ebay_zahlung_out SET fBetrag = CASE WHEN fBetrag < 0 THEN -1E+12 ELSE 1E+12 END WHERE fBetrag IS NOT NULL AND (fBetrag > 1E+12 OR fBetrag < -1E+12 )
UPDATE dbo.pf_amazon_angebot SET fPrice = CASE WHEN fPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPrice IS NOT NULL AND (fPrice > 1E+12 OR fPrice < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fAPAMaxPreis = CASE WHEN fAPAMaxPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAPAMaxPreis IS NOT NULL AND (fAPAMaxPreis > 1E+12 OR fAPAMaxPreis < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fAPAMinPreis = CASE WHEN fAPAMinPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAPAMinPreis IS NOT NULL AND (fAPAMinPreis > 1E+12 OR fAPAMinPreis < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fAPAPreisabstand = CASE WHEN fAPAPreisabstand < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAPAPreisabstand IS NOT NULL AND (fAPAPreisabstand > 1E+12 OR fAPAPreisabstand < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fPreis = CASE WHEN fPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreis IS NOT NULL AND (fPreis > 1E+12 OR fPreis < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fPreisSeller1 = CASE WHEN fPreisSeller1 < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreisSeller1 IS NOT NULL AND (fPreisSeller1 > 1E+12 OR fPreisSeller1 < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fSalePrice = CASE WHEN fSalePrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE fSalePrice IS NOT NULL AND (fSalePrice > 1E+12 OR fSalePrice < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fVersandkosten = CASE WHEN fVersandkosten < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVersandkosten IS NOT NULL AND (fVersandkosten > 1E+12 OR fVersandkosten < -1E+12 )
UPDATE dbo.pf_amazon_angebot_ext SET fVersandSeller1 = CASE WHEN fVersandSeller1 < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVersandSeller1 IS NOT NULL AND (fVersandSeller1 > 1E+12 OR fVersandSeller1 < -1E+12 )
UPDATE dbo.pf_amazon_angebot_neu SET fPrice = CASE WHEN fPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPrice IS NOT NULL AND (fPrice > 1E+12 OR fPrice < -1E+12 )
UPDATE dbo.pf_amazon_apa_preis SET fPreis = CASE WHEN fPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreis IS NOT NULL AND (fPreis > 1E+12 OR fPreis < -1E+12 )
UPDATE dbo.pf_amazon_apa_usersettings SET fAPAPreisabstand = CASE WHEN fAPAPreisabstand < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAPAPreisabstand IS NOT NULL AND (fAPAPreisabstand > 1E+12 OR fAPAPreisabstand < -1E+12 )
UPDATE dbo.pf_amazon_bestellung SET fItemPromotionDiscount = CASE WHEN fItemPromotionDiscount < 0 THEN -1E+12 ELSE 1E+12 END WHERE fItemPromotionDiscount IS NOT NULL AND (fItemPromotionDiscount > 1E+12 OR fItemPromotionDiscount < -1E+12 )
UPDATE dbo.pf_amazon_bestellung SET fShipPromotionDiscount = CASE WHEN fShipPromotionDiscount < 0 THEN -1E+12 ELSE 1E+12 END WHERE fShipPromotionDiscount IS NOT NULL AND (fShipPromotionDiscount > 1E+12 OR fShipPromotionDiscount < -1E+12 )
UPDATE dbo.pf_amazon_bestellung SET fVersandkosten = CASE WHEN fVersandkosten < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVersandkosten IS NOT NULL AND (fVersandkosten > 1E+12 OR fVersandkosten < -1E+12 )
UPDATE dbo.pf_amazon_bestellungpos SET fGeschenkverpackungKosten = CASE WHEN fGeschenkverpackungKosten < 0 THEN -1E+12 ELSE 1E+12 END WHERE fGeschenkverpackungKosten IS NOT NULL AND (fGeschenkverpackungKosten > 1E+12 OR fGeschenkverpackungKosten < -1E+12 )
UPDATE dbo.pf_amazon_bestellungpos SET fItemPrice = CASE WHEN fItemPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE fItemPrice IS NOT NULL AND (fItemPrice > 1E+12 OR fItemPrice < -1E+12 )
UPDATE dbo.pf_amazon_bestellungpos SET fItemTax = CASE WHEN fItemTax < 0 THEN -1E+12 ELSE 1E+12 END WHERE fItemTax IS NOT NULL AND (fItemTax > 1E+12 OR fItemTax < -1E+12 )
UPDATE dbo.pf_amazon_bestellungpos SET fShippingPrice = CASE WHEN fShippingPrice < 0 THEN -1E+12 ELSE 1E+12 END WHERE fShippingPrice IS NOT NULL AND (fShippingPrice > 1E+12 OR fShippingPrice < -1E+12 )
UPDATE dbo.pf_amazon_bestellungpos SET fShippingTax = CASE WHEN fShippingTax < 0 THEN -1E+12 ELSE 1E+12 END WHERE fShippingTax IS NOT NULL AND (fShippingTax > 1E+12 OR fShippingTax < -1E+12 )
UPDATE dbo.pf_amazon_repricehistory SET fPreisAlt = CASE WHEN fPreisAlt < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreisAlt IS NOT NULL AND (fPreisAlt > 1E+12 OR fPreisAlt < -1E+12 )
UPDATE dbo.pf_amazon_repricehistory SET fPreisNeu = CASE WHEN fPreisNeu < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPreisNeu IS NOT NULL AND (fPreisNeu > 1E+12 OR fPreisNeu < -1E+12 )
UPDATE dbo.tartikel SET fAbnahmeintervall = CASE WHEN fAbnahmeintervall < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAbnahmeintervall IS NOT NULL AND (fAbnahmeintervall > 1E+12 OR fAbnahmeintervall < -1E+12 )
UPDATE dbo.tartikel SET fArtGewicht = CASE WHEN fArtGewicht < 0 THEN -1E+12 ELSE 1E+12 END WHERE fArtGewicht IS NOT NULL AND (fArtGewicht > 1E+12 OR fArtGewicht < -1E+12 )
UPDATE dbo.tartikel SET fEKNetto = CASE WHEN fEKNetto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fEKNetto IS NOT NULL AND (fEKNetto > 1E+12 OR fEKNetto < -1E+12 )
UPDATE dbo.tartikel SET fGewicht = CASE WHEN fGewicht < 0 THEN -1E+12 ELSE 1E+12 END WHERE fGewicht IS NOT NULL AND (fGewicht > 1E+12 OR fGewicht < -1E+12 )
UPDATE dbo.tartikel SET fPackeinheit = CASE WHEN fPackeinheit < 0 THEN -1E+12 ELSE 1E+12 END WHERE fPackeinheit IS NOT NULL AND (fPackeinheit > 1E+12 OR fPackeinheit < -1E+12 )
UPDATE dbo.tartikel SET fVKNetto = CASE WHEN fVKNetto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVKNetto IS NOT NULL AND (fVKNetto > 1E+12 OR fVKNetto < -1E+12 )
UPDATE dbo.tartikel SET fVPEWert = CASE WHEN fVPEWert < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVPEWert IS NOT NULL AND (fVPEWert > 1E+12 OR fVPEWert < -1E+12 )
UPDATE dbo.tartikel SET nLagerbestand = CASE WHEN nLagerbestand < 0 THEN -1E+12 ELSE 1E+12 END WHERE nLagerbestand IS NOT NULL AND (nLagerbestand > 1E+12 OR nLagerbestand < -1E+12 )
UPDATE dbo.tartikel SET nMidestbestand = CASE WHEN nMidestbestand < 0 THEN -1E+12 ELSE 1E+12 END WHERE nMidestbestand IS NOT NULL AND (nMidestbestand > 1E+12 OR nMidestbestand < -1E+12 )
UPDATE dbo.tartikel SET nMindestbestellmaenge = CASE WHEN nMindestbestellmaenge < 0 THEN -1E+12 ELSE 1E+12 END WHERE nMindestbestellmaenge IS NOT NULL AND (nMindestbestellmaenge > 1E+12 OR nMindestbestellmaenge < -1E+12 )
UPDATE dbo.tArtikelEinkaufsliste SET fAnzahl = CASE WHEN fAnzahl < 0 THEN -1E+12 ELSE 1E+12 END WHERE fAnzahl IS NOT NULL AND (fAnzahl > 1E+12 OR fAnzahl < -1E+12 )
UPDATE dbo.tArtikelEinkaufsliste SET fEKNettoLieferant = CASE WHEN fEKNettoLieferant < 0 THEN -1E+12 ELSE 1E+12 END WHERE fEKNettoLieferant IS NOT NULL AND (fEKNettoLieferant > 1E+12 OR fEKNettoLieferant < -1E+12 )
UPDATE dbo.tArtikelHistory SET fEKNetto = CASE WHEN fEKNetto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fEKNetto IS NOT NULL AND (fEKNetto > 1E+12 OR fEKNetto < -1E+12 )
UPDATE dbo.tArtikelHistory SET fLagerBestand = CASE WHEN fLagerBestand < 0 THEN -1E+12 ELSE 1E+12 END WHERE fLagerBestand IS NOT NULL AND (fLagerBestand > 1E+12 OR fLagerBestand < -1E+12 )
UPDATE dbo.tArtikelHistory SET fLagerBestandGesamt = CASE WHEN fLagerBestandGesamt < 0 THEN -1E+12 ELSE 1E+12 END WHERE fLagerBestandGesamt IS NOT NULL AND (fLagerBestandGesamt > 1E+12 OR fLagerBestandGesamt < -1E+12 )
UPDATE dbo.tArtikelHistory SET fReserviert = CASE WHEN fReserviert < 0 THEN -1E+12 ELSE 1E+12 END WHERE fReserviert IS NOT NULL AND (fReserviert > 1E+12 OR fReserviert < -1E+12 )
UPDATE dbo.tArtikelHistory SET fVerfuegbar = CASE WHEN fVerfuegbar < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVerfuegbar IS NOT NULL AND (fVerfuegbar > 1E+12 OR fVerfuegbar < -1E+12 )
UPDATE dbo.tArtikelRankingGlobal SET nAnteilProzent = CASE WHEN nAnteilProzent < 0 THEN -1E+12 ELSE 1E+12 END WHERE nAnteilProzent IS NOT NULL AND (nAnteilProzent > 1E+12 OR nAnteilProzent < -1E+12 )
UPDATE dbo.tArtikelRankingGlobal SET nPauschal = CASE WHEN nPauschal < 0 THEN -1E+12 ELSE 1E+12 END WHERE nPauschal IS NOT NULL AND (nPauschal > 1E+12 OR nPauschal < -1E+12 )
UPDATE dbo.tArtikelRankingZeitraum SET nAnteilProzent = CASE WHEN nAnteilProzent < 0 THEN -1E+12 ELSE 1E+12 END WHERE nAnteilProzent IS NOT NULL AND (nAnteilProzent > 1E+12 OR nAnteilProzent < -1E+12 )
UPDATE dbo.tArtikelRankingZeitraum SET nPauschal = CASE WHEN nPauschal < 0 THEN -1E+12 ELSE 1E+12 END WHERE nPauschal IS NOT NULL AND (nPauschal > 1E+12 OR nPauschal < -1E+12 )
UPDATE dbo.tbestelleigenschaft SET fNettoPreis = CASE WHEN fNettoPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fNettoPreis IS NOT NULL AND (fNettoPreis > 1E+12 OR fNettoPreis < -1E+12 )
UPDATE dbo.tbestellpos SET fEKNetto = CASE WHEN fEKNetto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fEKNetto IS NOT NULL AND (fEKNetto > 1E+12 OR fEKNetto < -1E+12 )
UPDATE dbo.tbestellpos SET fMwSt = CASE WHEN fMwSt < 0 THEN -1E+12 ELSE 1E+12 END WHERE fMwSt IS NOT NULL AND (fMwSt > 1E+12 OR fMwSt < -1E+12 )
UPDATE dbo.tbestellpos SET fRabatt = CASE WHEN fRabatt < 0 THEN -1E+12 ELSE 1E+12 END WHERE fRabatt IS NOT NULL AND (fRabatt > 1E+12 OR fRabatt < -1E+12 )
UPDATE dbo.tbestellpos SET fVKNetto = CASE WHEN fVKNetto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVKNetto IS NOT NULL AND (fVKNetto > 1E+12 OR fVKNetto < -1E+12 )
UPDATE dbo.tbestellpos SET fVKPreis = CASE WHEN fVKPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVKPreis IS NOT NULL AND (fVKPreis > 1E+12 OR fVKPreis < -1E+12 )
UPDATE dbo.tbestellung SET fFaktor = CASE WHEN fFaktor < 0 THEN -1E+12 ELSE 1E+12 END WHERE fFaktor IS NOT NULL AND (fFaktor > 1E+12 OR fFaktor < -1E+12 )
UPDATE dbo.tbestellung SET fGutschein = CASE WHEN fGutschein < 0 THEN -1E+12 ELSE 1E+12 END WHERE fGutschein IS NOT NULL AND (fGutschein > 1E+12 OR fGutschein < -1E+12 )
UPDATE dbo.tbestellung SET fRabatt = CASE WHEN fRabatt < 0 THEN -1E+12 ELSE 1E+12 END WHERE fRabatt IS NOT NULL AND (fRabatt > 1E+12 OR fRabatt < -1E+12 )
UPDATE dbo.tbestellung SET fSkonto = CASE WHEN fSkonto < 0 THEN -1E+12 ELSE 1E+12 END WHERE fSkonto IS NOT NULL AND (fSkonto > 1E+12 OR fSkonto < -1E+12 )
UPDATE dbo.tbestellung SET fVersandBruttoPreis = CASE WHEN fVersandBruttoPreis < 0 THEN -1E+12 ELSE 1E+12 END WHERE fVersandBruttoPreis IS NOT NULL AND (fVersandBruttoPreis > 1E+12 OR fVersandBruttoPreis < -1E+12 )
UPDATE dbo.tbestellung SET fZusatzGewicht = CASE WHEN fZusatzGewicht < 0 THEN -1E+12 ELSE 1E+12 END WHERE fZusatzGewicht IS NOT NULL AND (fZusatzGewicht > 1E+12 OR fZusatzGewicht < -1E+12 )
Der Text ist leider zu lang:
Seite 2 folgt:
