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?