Create a stored procedure that will display all transactions for a specific customer

So you want us to tell you how to fix errors we can't see, in code we can't see, running against a database we can't see, on a server we can't access?

Click the green "Improve question" link. Add the basic structure of the tables you are trying to query, some sample data, and the expected output. Explain precisely what you are trying to achieve, add the relevant parts of the code you have tried, and the full details of the error(s) you are getting.

Without that information, nobody can give you specific advice.