I am tiring to find the best way to write this. I creating a procedure that has multiple inputs and in them multiple choices. these come in from an input form in an application
So, for example it has sale date, recall date, sale Id, current balance, company id.
this issue is that sale date or as starting sale date and ending sale date and this could also have this and the same choice recall date; and could have both, as well as the other items listed.
So, I could do this with quite a number of if statements like If recall date is null is Start recall date Null? this would get crazy.
I was wondering if anyone has a better way to write this ?