It looks like it's not returning the ID because it's not in scope from EXECing the query in the SP, the following works for it, but you're limited to 4000...