I've managed to get a script out and alter it to use temp tables
CREATE TABLE #tblChargeBacks(
[ID] [int] IDENTITY(1,1) NOT NULL,
[amount] [float] NULL,
[OrderID] [nvarchar](50) NULL,
[OperationDate] [datetime] NULL,
[type] [nvarchar](50) NULL,
CONSTRAINT [PK_tblChargeBacks] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE #tblMoneyRequests(
[ID] [int] IDENTITY(1,1) NOT NULL,
[amount] [float] NULL,
[OrderID] [nvarchar](50) NULL,
[OperationDate] [datetime] NULL,
[type] [nvarchar](50) NULL,
CONSTRAINT [PK_tblMoneyRequests] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE #tblTransactions(
[ID] [int] IDENTITY(1,1) NOT NULL,
[OrderID] [nvarchar](50) NULL,
[amount] [float] NULL,
[Comission] [float] NULL,
[fee] [float] NULL,
[OperationDate] [datetime] NULL,
[type] [nvarchar](50) NULL,
CONSTRAINT [PK_Transactions] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT #tblChargeBacks ON
GO
INSERT #tblChargeBacks ([ID], [amount], [OrderID], [OperationDate], [type]) VALUES (1, 7, N'24', CAST(0x0000A12C00000000 AS DateTime), N'CHARGEBACK')
GO
INSERT #tblChargeBacks ([ID], [amount], [OrderID], [OperationDate], [type]) VALUES (2, 7, N'24', CAST(0x0000A0CC00000000 AS DateTime), N'CHARGEBACK')
GO
SET IDENTITY_INSERT #tblChargeBacks OFF
GO
SET IDENTITY_INSERT #tblMoneyRequests ON
GO
INSERT #tblMoneyRequests ([ID], [amount], [OrderID], [OperationDate], [type]) VALUES (1, 9, N'-', CAST(0x0000A12A00000000 AS DateTime), N'MONEYREQUEST')
GO
INSERT #tblMoneyRequests ([ID], [amount], [OrderID], [OperationDate], [type]) VALUES (2, 9, N'-', CAST(0x0000A12800000000 AS DateTime), N'MONEYREQUEST')
GO
INSERT #tblMoneyRequests ([ID], [amount], [OrderID], [OperationDate], [type]) VALUES (3, 9, N'-', CAST(0x0000A12200000000 AS DateTime), N'MONEYREQUEST')
GO
SET IDENTITY_INSERT #tblMoneyRequests OFF
GO
SET IDENTITY_INSERT #tblTransactions ON
GO
INSERT #tblTransactions ([ID], [OrderID], [amount], [Comission], [fee], [OperationDate], [type]) VALUES (1, N'24', 1, 4, 5, CAST(0x0000A0CA00000000 AS DateTime), N'TRANSACTION')
GO
INSERT #tblTransactions ([ID], [OrderID], [amount], [Comission], [fee], [OperationDate], [type]) VALUES (2, N'25', 2, 4, 5, CAST(0x0000A0CA00000000 AS DateTime), N'TRANSACTION')
GO
INSERT #tblTransactions ([ID], [OrderID], [amount], [Comission], [fee], [OperationDate], [type]) VALUES (3, N'26', 3, 4, 5, CAST(0x0000A0CC00000000 AS DateTime), N'TRANSACTION')
GO
INSERT #tblTransactions ([ID], [OrderID], [amount], [Comission], [fee], [OperationDate], [type]) VALUES (4, N'27', 4, 4, 5, CAST(0x0000A0CD00000000 AS DateTime), N'TRANSACTION')
GO
SET IDENTITY_INSERT #tblTransactions OFF
On tblMoneyRequests as OrderId on the table is blank (or rather '-'), so I cant see a way to join these rows to the other tables.
_________________________________________________________________________
SSC Guide to Posting and Best Practices