Let's try something and see how it goes:
CREATE TABLE #tTransactions (
    ID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
    [GUID] char(50) NOT NULL,
    ProdNo int NOT NULL,
    UUID char(50)...

Without a  much closer look at your environment, all I can do is make wild guesses.   First question that this post makes me ask is whether your existing environment is...

I think this should work:
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE #Account_Customer (
  [Per_id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
  [App_acc] [nvarchar](16) NOT...