I had to do something similar recently and created the select as dynamic sql, selecting the result into a temp table. You can then use a standard select to get...