The SqlJunkies weblog site is really starting to fill out, it's fantastic to have so many SQL experts posting in one place! Oh, and I'm not just saying that because I agree with Donny Mack's views on SPs; well, partially, reporting is still a pain but I had discovered a good link to a version using the SP to generate the Dynamic SQL which seemed like a sound approach.