I have really enjoyed this recentdiscussion on stored procedures vs. dynamic sql... my personal view is that they both have a time and place, and the discussion should not be stored procedures vs. dynamic sql but rather when one is better than the other and in what situations. Anyway, here are some links that have nothing to do with this discussion.