I'm really rusty with stored procedures so would appreciate some help.
We are looking to build something in Excel where the user enters a start date and an end date into two cells and a piece of VBA / SQL code uploads those two values into a database table.
Is it possible to execute a stored procedure that captures the two values and uses them as parameters?
So my procedure would be called EXEC dbo.Monthly_Report startdate enddate
Hopefully that makes sense. Any advice appreciated.