Unanswered: Multiple values in a stored procedure with single parameter.
I have the following stored procedure. the date parameter(BATCH_RUN_DATE) generates html reports for that specific date. I have to produce these reports for few months and would like to avoid entering the date parameter everytime.
I would like to input a range for the BATCH_RUN_DATE to produce all these daily reports in one go.
Any help will be appreciated.
RE: Multiple values in a stored procedure with single parameter
Thanks for the reply.
I have run the script for range 20 OCt 2011 to 24 Oct 2011. and it has created respective folders for the reports but it has totaly ignored the date range and has populated all the folders with the same set of reports. The reports generated are for either 27th or 28th of October (This is hard coded in the sp.