IF NOT OBJECT_ID('tempdb..#RMC_BDCBPW_ReturnTable') IS NULL
	DROP TABLE #RMC_BDCBPW_ReturnTable
	
SELECT 
IDENTITY(BIGINT ,1 ,1) AS RowIndex
,CONVERT(VARCHAR(22) ,GETDATE() ,114) AS Gate1_Name
,CONVERT(VARCHAR(22) ,GETDATE() ,114) AS Gate2_Name
,CONVERT(VARCHAR(22) ,GETDATE() ,114) AS Gate3_Name
,CONVERT(VARCHAR(22) ,GETDATE() ,114) AS Gate4_Name
,CONVERT(VARCHAR(22) ,GETDATE() ,114) AS Gate5_Name
INTO #RMC_BDCBPW_ReturnTable

TRUNCATE TABLE #RMC_BDCBPW_ReturnTable

INSERT INTO #RMC_BDCBPW_ReturnTable(Gate1_Name ,Gate2_Name ,Gate3_Name ,Gate4_Name ,Gate5_Name)
SELECT 
 CONVERT( VARCHAR(20) ,GETDATE() + 1 ,121) AS Gate1_Name
,CONVERT( VARCHAR(20) ,GETDATE() + 2 ,121) AS Gate2_Name
,CONVERT( VARCHAR(20) ,GETDATE() + 3 ,121) AS Gate3_Name
,CONVERT( VARCHAR(20) ,GETDATE() + 4 ,121) AS Gate4_Name
,CONVERT( VARCHAR(20) ,GETDATE() + 5 ,121) AS Gate5_Name
WAITFOR DELAY '00:00:00.700'
GO 10
-- Execute the Query for Ten times

SELECT * FROM #RMC_BDCBPW_ReturnTable
SELECT 
	Tab1.FieldName AS [1] 
	,Tab2.FieldName AS [2]
	,Tab3.FieldName AS [3]
FROM
(SELECT 1 AS RowNo ,Gate1_Name AS FieldName FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 1
UNION SELECT 2 AS RowNo ,Gate2_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 1
UNION SELECT 3 AS RowNo ,Gate3_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 1
UNION SELECT 4 AS RowNo ,Gate4_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 1
UNION SELECT 5 AS RowNo ,Gate5_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 1
) AS Tab1
INNER JOIN
(SELECT 1 AS RowNo ,Gate1_Name AS FieldName FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 2
UNION SELECT 2 AS RowNo ,Gate2_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 2
UNION SELECT 3 AS RowNo ,Gate3_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 2
UNION SELECT 4 AS RowNo ,Gate4_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 2
UNION SELECT 5 AS RowNo ,Gate5_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 2
) AS Tab2
ON Tab2.RowNo = Tab1.RowNo
INNER JOIN
(SELECT 1 AS RowNo ,Gate1_Name AS FieldName FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 3
UNION SELECT 2 AS RowNo ,Gate2_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 3
UNION SELECT 3 AS RowNo ,Gate3_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 3
UNION SELECT 4 AS RowNo ,Gate4_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 3
UNION SELECT 5 AS RowNo ,Gate5_Name FROM #RMC_BDCBPW_ReturnTable WITH (NOLOCK) WHERE RowIndex = 3
) AS Tab3
ON Tab3.RowNo = Tab1.RowNo
--Etc....