10 Oct 2014 by Maciej Los
Have a look at example:DECLARE @tmp TABLE(ID INT IDENTITY(1,1), aDATE DATETIME, Pallets INT)INSERT INTO @tmp (aDATE, Pallets)VALUES('2014-09-29', 4),('2014-09-30', 5),('2014-10-01', 6),('2014-10-02', 1),('2014-10-06', -2),('2014-10-07', 1),('2014-10-08', -3)SELECT t2.ID, t2.aDATE,...