>Being available to all users won't be a big concern the data is not proprietary or secure in nature.

You're missing the point. All users will share the same temp table and could override each other data before they get used by subsequent query.