>It's that views are too limiting, that's all. They had their years, and used them well, IMO.
Agreed.
Unfortunately I came to that realization much too late and spend endless wasted hours trying to make do with views.
A stored procedure can do everything that a view can do and allows parameters and ORDER BY.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.