1. On the dynamic SQL issue , I vote for Frans . I have architected and developed systems using both approaches, and the amount of time required to code, debug and maintain SPs just isn't worth the marginal perf gains. Enough said on that by everyone