How many rows were you trying to insert into the table you were creating? If that also was 84,000, try inserting a few rows - maybe 10 - to see if it is indeed timeout due to the insert taking too long for the 84,000 rows.
If you get the same message while trying to insert 10 rows, it could be that the table is blocked by some other process. Start the insert job in one query editor window, and in another, run "exec sp_who2" and look at the "Blk By" column. You should be able to see if your insert job is being blocked by some other process.
If you are able to insert 10 rows, but not 84,000 it indeed could be timeout due to resources being insufficient. But 84,000 is not a huge number, so that seems a bit strange.
Does your query actually have 84,000 items in the IN(whatever 84,000 ids are) part of your query? If you do, instead of doing that, insert the 84,000 pcs_id's into a temp table and join to that table.
JamesK, Yes I am able to load in 10 rows of data. Yes, I have 84,000 records and it does seem a bit strange that I am not able to do this simple query. I have loaded more than that before in other SQL codes that I have done.