Without an actual execution plan. table structure or index info, we're just stabbing in the wind... Based on the code pattern alone... Here a few alternatives that are logically equivalent...

This should do the trick.
-- Test data ...
IF OBJECT_ID('tempdb..#TABLEA ', 'U') IS NOT NULL
  DROP TABLE #TABLEA;

CREATE TABLE #TABLEA (
    PK_ID INT NOT...

I like executing all my SELECT queries using the TABLOCKX hint... I'm selfish like that... 😀

If you can get the raw file into a staging table, you can use something like the following to get into the shape you're looking for.

--...

I just wanted to give everyone, Tom, Jeff, Hugo, Wayne & Steve a huge THANK YOU for providing your input, sharing your experiences and providing links to additional resources... 
I'm...