in the intail post i forgot the from so select * into ##tmp1 from xxxx

I have created a db with the companyname so xxxxdb. so the source table is from xxxxdb

this is a simple issue. creating temp tables is standard.

sql server 2014 using odbc

thanks! yes we will have a very low number of users. many reports will run off hours. We need it to merge data and

aggregate.

Any ideas on the disk drive?