• 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