I modified the parameter datatypes, stored procedure naming convention and added a rule to take into account the mindate = max date.

The procedure was created without errors.

If the parameters are valid I would like to return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal and Balance for each invoice for which the InvoiceDate is within the date range, sorted with the earliest invoice first.

I executed my procedure as follows with 2 date parameters but did not get any results.

exec spDateRange '2008-07-01', '2008-08-01'