Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
You can write a stored procedure that creates or uses other stored procedures but keep in mind stored procedures are genereally not temporary objects (as in they are created/dropped for the span of another stored procedure) although there's nothing to stop you from doing so.