A union of curiosity and data science

When creating a data source with temp tables avoid temp table errors. 

"Invalid object name #"

You can add the following lines to your query or procedure.

SET FMTONLY OFF
SET NOCOUNT ON

This will prevent formatting and count errors.