Le nom de la colonne SQL ou le nombre de valeurs fournies ne correspond pas à la définition de la table

J'obtiens cette erreur quand j'essaye d'exécuter ma procédure stockée, j'ai vérifié que les insertions correspondent au select, qui a semblé être le problème pendant la plupart du time cette question est posée. Autant que je puisse dire, ils correspondent donc quelque chose d'autre doit être faux.

Merci d'avance

Erreur:

Msg 213, niveau 16, état 1, procédure system_IncreaseCustomTariffs, ligne 36
Le nom de la colonne ou le nombre de valeurs fournies ne correspond pas à la définition de la table.

• Insérer dans une table SQL en utilisant select avec les valeurs de colonne d'un autre select
• Importer une feuille de calcul Excel tous les soirs dans la database mssql
• Amélioration du triggersur d'insertion SQL Server
• (SQL Server 2005) Un bon moyen de gérer un grand nombre d'instructions d'insertion?
• Oracle insert de la fonction

Code:

--This sp is used by doRateIncrease.exe ALTER PROCEDURE [dbo].[system_IncreaseCustomTariffs] @Increase money, @ProgramType varchar(30), @StartDate varchar(10) = NULL, @StopDate varchar(10) = NULL, @Exclude varchar(1024) = '' AS SET NOCOUNT ON DECLARE @OldFreightId int, @CustFreightId int, @BillAcct int, @User varchar(30) SET @User = 'Increase_' + Replace(Convert(varchar(10), GetDate(), 101),'/', '-') --Delete existing tariffs DECLARE C1 CURSOR FOR SELECT CustFreightId FROM CustFreightProgramMaster WHERE ProgramType = @ProgramType and CreateUsr = @User OPEN C1 FETCH NEXT FROM C1 INTO @CustFreightId WHILE (@@FETCH_STATUS = 0) BEGIN EXECUTE delete_CustFreightProgramMaster @CustFreightId = @CustFreightId FETCH NEXT FROM C1 INTO @CustFreightId END CLOSE C1 DEALLOCATE C1 --Load exclusion table CREATE TABLE #Exclude (parseValue VARCHAR(100)) INSERT INTO #Exclude SELECT * FROM dbo.Parse (@Exclude, ',') WHERE IsNull(parseValue,'') <> '' --Get all active tariffs DECLARE Increase CURSOR FOR SELECT CustFreightId, BillAcct FROM CustFreightProgramMaster WHERE ProgramType = @ProgramType and Convert(varchar(10), GetDate(), 101) Between StartDate and StopDate OPEN Increase FETCH NEXT FROM Increase INTO @OldFreightId, @BillAcct WHILE (@@FETCH_STATUS = 0) BEGIN --If BillAcct excluded from increase just extend stop date IF EXISTS (SELECT * FROM #Exclude WHERE Cast(parseValue as int)= @BillAcct) BEGIN --Extend existing tariff to new stop date UPDATE CustFreightProgramMaster SET StopDate = @StopDate WHERE CustFreightId = @OldFreightId END --Create new tariff ELSE BEGIN --Expire existing tariff 1 day prior to start on new tariff UPDATE CustFreightProgramMaster SET StopDate = DateAdd(day, -1, @StartDate) WHERE CustFreightId = @OldFreightId --Create new program master INSERT INTO CustFreightProgramMaster(BillAcct, ProgramType, BiDirect, StartDate, StopDate, AbsoluteMinimum, MaxDiscount, MaxPalletWeight, CreateSvr, CreateTrm, CreateUsr, CreateDT) SELECT BillAcct, ProgramType, BiDirect, @StartDate, @StopDate, AbsoluteMinimum, MaxDiscount, MaxPalletWeight, CreateSvr, CreateTrm, @User, GetDate() FROM CustFreightProgramMaster WHERE CustFreightId = @OldFreightId --Get new FreightId SET @CustFreightId = 0 SET @CustFreightId = SCOPE_IDENTITY() IF IsNull(@CustFreightId,0) = 0 BEGIN RAISERROR('Tariff not created.',16,1) RETURN END --Copy Origin Zones INSERT INTO CustFreightProgramOriginZones (CustFreightId, ZoneId, CreateSvr, CreateTrm, CreateUsr, CreateDT) SELECT @CustFreightId, ZoneId, CreateSvr, CreateTrm, @User, GetDate() FROM CustFreightProgramOriginZones WHERE CustFreightId = @OldFreightId --Copy Destination Zones INSERT INTO CustFreightProgramDestZones (CustFreightId, ZoneId, CreateSvr, CreateTrm, CreateUsr, CreateDT) SELECT @CustFreightId, ZoneId, CreateSvr, CreateTrm, @User, GetDate() FROM CustFreightProgramDestZones WHERE CustFreightId = @OldFreightId --Update Customer Program Master program description UPDATE CustFreightProgramMaster SET ProgramDesc = dbo.BuildCustFreightProgramDesc(CustFreightId) WHERE CustFreightId = @CustFreightId --Copy weight breaks, apply increase INSERT INTO CustFreightProgramWeightBreaks (CustFreightId, LowValue, HighValue, UnitCost, CreateSvr, CreateTrm, CreateUsr, CreateDT) SELECT @CustFreightId, LowValue, HighValue, dbo.IncreaseUnitCost(@ProgramType, UnitCost, @Increase), CreateSvr, CreateTrm, @User, GetDate() FROM CustFreightProgramWeightBreaks WHERE CustFreightId = @OldFreightId --Copy pallet breaks, apply increase INSERT INTO CustFreightProgramPalletRates (CustFreightId, LowValue, HighValue, UnitCost, CreateSvr, CreateTrm, CreateUsr, CreateDT) SELECT @CustFreightId, LowValue, HighValue, dbo.IncreaseUnitCost(@ProgramType, UnitCost, @Increase), CreateSvr, CreateTrm, @User, GetDate() FROM CustFreightProgramPalletRates WHERE CustFreightId = @OldFreightId END FETCH NEXT FROM Increase INTO @OldFreightId, @BillAcct END CLOSE Increase DEALLOCATE Increase --Clean up DROP TABLE #Exclude 

• Utilisation de MERGE avec la même table source / cible dans Sql Server
• Les données string ou binary seraient tronquées dans asp.net
• Comment get les valeurs d'identité des loggings nouvellement insérés ou déjà existants?
• INSÉREZ DANS UN CAS CHOISI
• INSÉRER … SUR LA MISE À JOUR DU CLÉ DUPLICAT (Deux keys à comparer)

 INSERT INTO #Exclude SELECT * FROM dbo.Parse (@Exclude, ',') WHERE IsNull(parseValue,'') <> '' 

 INSERT INTO #Exclude SELECT [Value - Or name of first column] FROM dbo.Parse (@Exclude, ',') WHERE IsNull(parseValue,'') <> ''