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