Stored Procedure with Parameters

How would you execute a stored procedure with the following parameters to produce return a result sets.
The stored procedure is already in production, but whenever i tried to call it, it's says missing parameters and these are the
listed parameters in SQL.


@starting_kper (char(6), Input, No default)
@starting_date (smalldatetime, Input, No default)
@ending_kper (char(6), Input, No default)
@ending_date (smalldatetime, Input, No default)
Who is Participating?
TempDBAConnect With a Mentor Commented:
exec storedprocedureName @starting_kper = 'value',@starting_date = 'datevalue', @ending_kper = 'value', @ending_date = 'datevalue'
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please show us...
The T-SQL you use to call the stored proc, with values as parameters
The CREATE PROC line in your SP that shows the parameters it accepts.
FavorableAuthor Commented:
Thank it worked
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.