I have to add a parameter to a stored procedure that will be passed from a ssrs report.
The parameter in the report will be a textbox with the option of being null and/ or blank.
I would like to see if I can get an example of how I can deal with the situation where the user does not enter a parameter, what the WHERE / AND condition look like?
WHERE OrderNumber = @OrderNumber <-- what if they pass null? how can I code around that?
Thank you much in advance.