help with creating a stored procedures with multi cursors.
I am completely new to sql and teradata(6weeks). and have been given an assignment, which had little instruction.
(Create a stored procedure that allows a user to select a bat’s manufacturer and (optionally) serial number using a stored procedure. The output should display all of the players who use the bat’s manufacturer. If the serial number is also provided, only display the players who use that bat’s manufacturer and serial number. Make sure you use a CREATE PROCEDURE call and insert this procedure into the existing database. ) this is a database through teradata that has been duplicated into my own database to be edited. This is what I got so far and it keeps returning two errors. I'd love help with a solution and best possible recommendation for learning sql quickly and efficiently. I appreciate the help in advance. and i'm sure this is the ugliest code you've seen, I aplogize. :-D