I currently have an sp that inserts the values of the input parameters into a table and that's all it does. Originally, the sp was written to use two parameters. We now need to add a third parameter, but this may not be required in all circumstances.
Is it possible to have the 3 parameters for the sp but not use all of them. I am trying to keep process simple by not having to write another sp for the users to run.
Any guidance would be appreciated.