Procedure or function !!! has too many arguments specified

by

You invoke the function with 2 parameters (@GenId and @Description):

EXEC etl.etl_M_Update_Promo @GenID, @Description

However you have declared the function to take 1 argument:

ALTER PROCEDURE [etl].[etl_M_Update_Promo]
    @GenId bigint = 0

SQL Server is telling you that [etl_M_Update_Promo] only takes 1 parameter (@GenId)

You can alter the procedure to take two parameters by specifying @Description.

ALTER PROCEDURE [etl].[etl_M_Update_Promo]
    @GenId bigint = 0,
    @Description NVARCHAR(50)
AS 

.... Rest of your code.

More Related Contents:

  1. Stored procedure that exports data into csv files only exports to one file
  2. Do clustered indexes have to be unique?
  3. Comma separated values in a database field
  4. SQL Server equivalent of WM_CONCAT function [duplicate]
  5. I dont know sql syntax for my table [closed]
  6. CROSS JOIN vs INNER JOIN in SQL
  7. How can I schedule a job to run a SQL query daily?
  8. Reset identity seed after deleting records in SQL Server
  9. Function vs. Stored Procedure in SQL Server
  10. Multiple INSERT statements vs. single INSERT with multiple VALUES
  11. Generate a resultset of incrementing dates in TSQL
  12. How to update Identity Column in SQL Server?
  13. Common Table Expression, why semicolon?
  14. T-SQL split string based on delimiter
  15. Concatenate values based on ID
  16. SQL Server SELECT into existing table
  17. How to check if a stored procedure exists before creating it
  18. Correct use of transactions in SQL Server
  19. Generate script in SQL Server Management Studio
  20. Select a Column in SQL not in Group By
  21. Split values over multiple rows [duplicate]
  22. How can I determine the status of a job?
  23. How can I generate a temporary table filled with dates in SQL Server 2000?
  24. How can I group time by hour or by 10 minutes?
  25. SQL Server: should I use information_schema tables over sys tables?
  26. TSQL – How to use GO inside of a BEGIN .. END block?
  27. Repeat Rows N Times According to Column Value
  28. SQL take just the numeric values from a varchar
  29. COALESCE Function in TSQL
  30. Execute sp_executeSql for select…into #table but Can’t Select out Temp Table Data

Leave a Comment