Procedure spVerificaPriOper has no parameters and arguments were supplied.
Bom dia,
O erro informado está ocorrendo nesta procedure. Gostaria de saber se há algum modo de resolver.
CREATE
PROC spVerificaPriOper
AS BEGIN
DECLARE @IdMember INT, @TradeAmount money, @TotalTradeAmount money;
SET @TradeAmount = (SELECT (FeeJoinCash) FROM FeePlan WHERE IdFeePlan = (SELECT IdFeePlan FROM Member WHERE IdMember = @IdMember))
SET @TotalTradeAmount = (SELECT (FeeJoinCash + FeeJoinBarter) FROM FeePlan WHERE IdFeePlan = (SELECT IdFeePlan FROM Member WHERE IdMember = @IdMember))
WHILE @IdMember NOT IN (SELECT IdMember FROM PriOper)
BEGIN
INSERT INTO AuthorizationTable (IdMemberBuyer,IdMemberSeller,IdTeamBuyer,IdBroker,EntryDate,TradeAmount,AuthorizationDescription,
AuthorizationStatus,IdTransactionType,FeeSellerCashCommission,TotalTradeAmount,Docum,Regalt,StrComentarios)
VALUES
(@IdMember, 199998, 18, 1, GETDATE(), @TradeAmount ,'Taxa de Incrio R$+UN$' ,'P' ,3, 0, @TotalTradeAmount, 1, 'I', 'Taxa de inscrio')
END
END
Abraços
DBA Vini