Select sum(Qty) as 'SumQty' from txfile where DespatchDate="give despatch date" group by CategoryId,ProductId
SELECT SUM(Qty) AS 'SUMQty' FROM FROM txfile WHERE DespatchDate=GETDATE() GROUP BY CategoryId;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)