<snip>
>3. cannot return a value directly, it only returns a result set, hence the temp table. also, must use temp table rather than table variable, since you cannot insert into...exec sp.. using a table var.
<snip>

Hi Trey,

Take a look at How to return a value from dynamicaly executed T-SQL code FAQ #8130