Your reply is most unhelpful. I suspect I may stop using SSC in future if this is the sort of reply I get.

To make it clear try this:

Create table foo (item char(1), changedate datetime, value int)

insert foo (item, changedate, value)

values (x, '2014-06-15', 0)

insert foo (item, changedate, value)

values (y, '2014-06-16', 1)

insert foo (item, changedate, value)

values (x, '2014-07-10', 1)

insert foo (item, changedate, value)

values (y, '2014-07-15', 2)

expected return values

2014-06-15, x, 0

2014-06-16, x, 0

2014-06-16, y, 1

2014-06-17, y, 1

etc etc

Anything else required?