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