On 2016-03-10 17:22, Stephen Russell wrote:
You will always have to change the UI. How many different places are you asking for the same data? If that was in a Sproc it is fixed all over the place now. If you have it as a statement you pas back you have to go to every occurrence in your app and make the change.
Reporting as well a UI.
Most of us will make the sproc to pull the data for a specific report.
Sure, reporting is fine...use stored procs and you never need to change the UI caller; but I thought you were talking about passing each field as parms to a stored proc.