Unanswered: Execute Stored Procedure Via Batch File
I have a stored procedure that generates some data and dumps it into a table. I need to export data using bcp based on the data that this procedure creates. So I know how to use bcp but don't know how to execute the procedure and pass it the two variables that it needs. I googled it and sqlcmd looks promising but can get the syntax right.
The two variables are the current year and school number ie. 1112, 0021