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

WITH Transactions AS (
	SELECT type, OrderId, OperationDate
	FROM #tblTransactions
	WHERE type = 'TRANSACTION'
	UNION ALL
	SELECT 'TRANSACTIONFEE', OrderID, OperationDate
	FROM #tblTransactions
	WHERE fee = 5
	UNION ALL
	SELECT 'COMISSION', OrderID, OperationDate
	FROM #tblTransactions
	WHERE Comission = 4
	UNION ALL
	SELECT type, OrderID, OperationDate
	FROM #tblMoneyRequests
	WHERE type = 'MONEYREQUEST'
	UNION ALL
	SELECT type, OrderID, OperationDate
	FROM #tblChargeBacks
	WHERE type = 'CHARGEBACK'
	)
SELECT type, OrderID, OperationDate
FROM Transactions
ORDER BY OperationDate, OrderID