this is totally groovy :w00t::smooooth:

where can I rate it THE best answer ever?

thank you so much!!!! This is what I need!!! just got back from vacations and what a pleasant...

Thanks Bteraberry, very useful hint. :w00t: I am learning

Hi Wayne,

Thanks a lot. Almost there :-D.

your join produces same result if the second table has two records for 6/23/2010

create table #tt (theDate datetime, quantity int)

insert into #tt values...

Thanks a lot for a quick reply. I apologize for my clumsiness in expression (English is not my first language) but you understood me very well :). I want...