This really sounds like a very basic homework assignment. Post the code you have written so far and I'm sure someone could help you tweak it if needed.
If you need the syntax for creating stored procs, BOL (books on line) is a good start.
Marvin Dillard
Senior Consultant
Claraview Inc