Posted by Doug on 09/29/21 11:38

create a view.

then create that same view "into" a stored procedure.

everything you can do in a view you can do in a stored procedure. But
in a stored procedure, you can do MUCH more, much faster, and with much
more flexibility.

And then, you can do a whole lot more then that with a stored
procedure. Think of a view as memorizing key strokes for an old time
macro.

Think of a stored procedure as a full fledged programming language.

[Back to original message]