At this point, what do you gain by trying to push this into a stored proc? I see no benefit. You might as well just execute the ad-hoc query directly instead of hiding it within the stored proc.

-Mike