Question On Stored Procedures

Hello and thank you for taking the time to read this message.I realize this maybe a little out of scope but I was just wondering if anybody had some suggestions about the best way to learn how to write stored procedures in sql sever. I've written some very simple ones, but the more research I do, the more I realize I don't know. I have learned some things by just getting into the ASP books but these really don't fully "tackle" the subject per say. If anybody has any suggestions as to a method or a book, it would be greatly appreciated.
Best Regards,
JasonCheck out this highly recommended book:

Rob Veiera's Professional SQL Server 2000 Programming

You might also consider Ken Henderson'sThe Guru's Guide to SQL Server Stored Procedures, XML, and HTML.

sql