Subquery Inner Join with Date Manipulation

SELECT     SUM(COST_15 * RUNTTL_15) AS EXTFROM         dbo.Transaction_History AS THINNER JOIN (SELECT     PRTNUM_15 AS PART, STKID_15 AS STK, CAST(MAX(CAST(CONVERT(DATE, TNXDTE_15, 120) AS CHAR(10)) + ‘ ‘ + LEFT(TNXTIM_15, 2) + ‘:’ + SUBSTRING(TNXTIM_15,                       3, 2) + ‘:’ + RIGHT(TNXTIM_15, 2)) AS DATETIME) AS DTFROM         dbo.Transaction_HistoryWHERE     (TNXCDE_15 IN (‘A’, ‘C’, ‘I’, ‘R’, ‘S’, ‘N’, ‘T’, ‘F’)) AND…

Read More