I have only been into SQL Server for a few months, and written several
stored procedures. Is there a good software product available that will
generate the SQL code for a stored procedure based on a visual interface?
Any help is appreciated.

Take a look at this website.
http://www.thedatabasearchitect.com/TheDatabaseHelper.htm

They used to advertise in SQL MAG.

>I have only been into SQL Server for a few months, and written several
>stored procedures. Is there a good software product available that will
>generate the SQL code for a stored procedure based on a visual interface?
>Any help is appreciated.
>