Problem: When creating a DataSet in VS from stored proc, if the stored proc 
uses temp tables, the dataset see's no columns and gives error #tempTableName 
is an invalid object.

Details: stored proc simple example does "select fname into #temp from 
customers ; Select fname from #temp;  Right click App_code in VS and create 
new dataset.  Point to stored proc, no DataColumns will appear.  This means 
that the reportViewer control cant use the datasource, the end consumer for 
me.

TIA
Don