I am trying to combine SCO_NET_VALUE + FRONT_END_NET_VALUE into new a totals table.
Any assistance would be appreciated.
Sample output:
Query:
SELECT
storenumber,
bbbtendertypetext,
SUM(CASE WHEN TerminalNumber > 91 THEN (financialamounttendered - financialchangeamount) END) AS SCO_NET_VALUE,
SUM(CASE WHEN TerminalNumber < 92 THEN (financialamounttendered - financialchangeamount) END) AS FRONT_END_NET_VALUE,
COUNT(CASE WHEN TerminalNumber > 91 THEN (transactionid) END) AS Transaction_Count_SCO,
COUNT(CASE WHEN TerminalNumber < 92 THEN (transactionid) END) AS Transaction_Count_Front_END
FROM
[AceTLogData].[Tlog].[tender]
WHERE
transactiondatetime > '2022-09-22 00:00:00.000'
AND transactiondatetime < '2022-09-23 00:03:00.000'
GROUP BY
storenumber, bbbtendertypetext
ORDER BY
storenumber