I ended up answering my own question, but -- for the benefit of anyone who might run across this thread -- add this parameter before the execute call, and this...

I'm sorry to waste your time on that question-- the dynamic SQL worked great. As I was cutting down the code so I could post in on a forum, I...

Also -- when I take the string of dynamic sql that is run by sp_executesql and run it manually in another query window, or even if I just call the...