Back in January I took a training course and when asked to write a stored procedure I just stared at my team leader like he was crazy.  After that, I played around with a few simple procedures, doing quick inserts and select statements, but nothing too fancy.  But, the last couple of weeks, it seems like stored procedures are all I've been working on.

Not that I'm complaining.  I need to learn.  Most of what I've been doing has just been adding error handling to long and complicated procedures that were already written by a DBA who knew what he was doing.  I can't tell you how many times I've typed "SET @ErrorCode = @@ERROR".   The great thing about being tossed into a complicated procedure to do error handling is that you have to learn what the procedure is doing so you know where to put the error handling.  I've managed to learn about cursers, transactions, best practices, and a whole host of other T-SQL stuff.

So basically, even though I've been given a simple task, the task itself has forced me to learn a lot.  It's been a great experience for me!