You don't need outputs on these if they are inputs, but your start date should be defined as being optional. In your sp at the moment you have it as a compulsory parameter.

For example, an SP where all parameters are needed:

Create proc AllParamsNeeds_sp @StartDate Date, @EndDate Date, @CustomerID int as

Select OrderDate,

CustomerID,

OrderID,

OrderValue

from Orders

where OrderDate between @StartDate and @EndDate

and (CustomerID = @CustomerID or @CustomerID = NULL)

Note that although i have catered for a NULL on CustomerID, it has to be supplied, so having it is pointless.

To make it optional, I would as = NULL as below:

Create proc AllParamsNeeds_sp @StartDate Date, @EndDate Date, @CustomerID int = NULL as

Select OrderDate,

CustomerID,

OrderID,

OrderValue

from Orders

where OrderDate between @StartDate and @EndDate

and (CustomerID = @CustomerID or @CustomerID = NULL)

This will allow the SP to not have a value for CustomerID passed, as it defaults its values.

Edit:

Question, if you are setting these values in the SP, why are they in your sp definition??