Garth has written numerous articles on SQLTeam including
Dynamic ORDER BY and
Using COALESCE to Build Comma-Delimited String. The book jacket reads "If you want to learn how to write stored procedures and triggers for Microsoft
SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers
is the book for you. You'll learn "real-world" coding and how to build
non-trivial applications. All of the examples covered in the book are available
for download, making it easier to work through over 5,000 lines of sample code . . ."