Ken,

It is true that any temp. tables created within dynamic sql are scoped to the dynamic sql. BUT, if the temp table exists BEFORE the dynamic sql, it is within scope:

CREATE TABLE #x (c int)

EXECUTE ('insert into c values (1)')

-Mike