• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

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.



Parameters

@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)
0
Favorable
Asked:
Favorable
1 Solution
 
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.
0
 
TempDBACommented:
exec storedprocedureName @starting_kper = 'value',@starting_date = 'datevalue', @ending_kper = 'value', @ending_date = 'datevalue'
0
 
FavorableAuthor Commented:
Thank it worked
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now