SELECT skuid,
SUM(CASE WHEN Online = 1 THEN -SalesAmount
ELSE SalesAmount
END) AS [Both],
SUM(CASE WHEN Online = 1 THEN SalesAmount
ELSE 0
END) AS [Online],
ClientName
FROM t_CombinedSalesDetails
WHERE ClientName = 'Asda'
AND SkuId = 200437
GROUP BY Skuid,
ClientName
ORDER BY skuid;
Returns: -
skuid Both Online ClientName
----------- --------------------- --------------------- --------------------------------------------------
200437 215183.35 16816.65 Asda
Or. . .
SELECT a.skuid,
SUM(a.SalesAmount - ISNULL(b.SalesAmount, 0)),
a.Online,
a.ClientName
FROM t_CombinedSalesDetails a
LEFT OUTER JOIN t_CombinedSalesDetails b ON a.SkuId = b.SkuId
AND a.Online < b.Online
WHERE a.ClientName = 'Asda'
AND a.SkuId = 200437
GROUP BY a.Skuid,
a.ClientName,
a.Online
ORDER BY a.skuid;
Returns: -
skuid Online ClientName
----------- --------------------- ------ --------------------------------------------------
200437 215183.35 0 Asda
200437 16816.65 1 Asda