Help with Stored Procedure in SQL Server

I need help completing a stored procedure in SQL Server 2008, and help in creating the Visual Basic .Net 2008 source code to execute the stored procedure. Attached are the detailed requirements, the database, and the existing VB .Net source code that you need to work with. ## Deliverables You must use the existing database You must use the same naming conventions of the existing stored procedures You must implement a stored procedure that is similar to the implementation of the existing stored procedures. In other words, alter the existing stored procedure, add the changes, and create it as a new stored procedure. You must use the existing classes that exist in the VB .Net solution. In other words, alter the existing functions, add the changes, and create it as a new function.