If you’re not sure how to create a procedure statement by your own design, then let us explain to aid in you becoming a master. You begin the script with CREATE PROCEDURE (must always be in caps).

When you use this form, a table is physically created as the statement is executed. The newly created table does not reflect subsequent changes in the underlying tables (in the query-expression). If ...