SQL Stored procedures

[mgray]

Can anyone recomend any resources on learning to write stored procedures. Online or in book format doesn't really matter. Thanks in advance.
Mike

[JimBolla]

my preferred resources are the Books Online that come w/ the SQL Enterprise tools and a book titled "Inside SQL Server 7.0" by Microsoft Press. these i use more of as reference materials than learning tools. while in the "learning stage" i would suggest "Beginning SQL Server 2000 Programming" by Wrox Press. they also have a "Professional SQL Server 2000 Programming" which would cover some more advanced topics and cut out some of the hand-holding.