Convert VB6 Code to SQL Procedure

I'm looking for a skilled professional to modify my Visual Basic 6 code and convert it into a SQL stored procedure. The main purpose of this task is to improve the performance and fix any existing bugs in the code.

Key Requirements:
- Modify the VB6 code with necessary syntax changes
- Optimize the code for better performance
- Identify and fix any bugs
- Convert the VB6 procedure into a SQL stored procedure
- Ensure the new stored procedure is capable of handling data manipulation tasks

Ideal Skills:
- Extensive experience with Visual Basic 6
- Proficient in SQL and stored procedures
- Strong bug-fixing and performance optimization skills
- Excellent understanding classic Ado and data manipulation techniques

Please note that the main functionality of the VB6 procedure that needs to be converted is primarily focused on data manipulation with SQL server