The last SELECT from your SP must be from a # table.

BCP evaluates output by recompiling procedure, before it's executed.

At the time of compilation temp table does not exist yet, therefore there is no output.