Something like this??

DECLARE @t TABLE(DeliveryDate DATE,Assigned INT,Unassigned INT, Total INT)

INSERT INTO @t(DeliveryDate,Assigned,Unassigned)

VALUES

('2013-04-29',1,0),

('2013-04-29',1,1),

('2013-04-29',1,1),

('2013-04-29',1,1),

('2013-04-30',0,0),

('2013-04-30',0,1),

('2013-05-01',0,0);

SELECT DeliveryDate,Assigned,Unassigned,

SUM(Assigned + Unassigned) OVER(PARTITION BY DeliveryDate) Total

FROM @t

ORDER BY DeliveryDate

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537