Tinkering with stored procedure parameters

Theoretically what i did is to make the procedures behave as if they do not have parameters when no parameter is passed to the procedure when it is called. This equivalent of passing a null to the procedure parameter...

Therefore if you call the procedure with no parameters the procedure will return all values...you will then only need to specify values for the parameters you need.

To achieve this instead of specifying your parameter as say:-

...WHERE CustomerID=@CustomerID specifiy

....WHERE CustomerID=COALESCE(@CustomerID,CustomerID)

With fine tuning you will find great potential of using stored procedure...

Contact me at clarence_assey@hotmail.com for more help