Any ideas on if I have a start date and end date and for each day there should be a specific value say SD="other" if a value is not there for that day I want to display that date..

example..
Start Date = 1/1/2012
End Date = 1/31/2012

Go get the records....

SD=other on 1/1/2012... display nothing
SD <>other on 1/2/2012 display 1/2/2012..

Thanks In Advance

Joe



Edited by jbalbo - 31 Jan 2012 at 7:36am

Thanks for getting back..
Yes, there are days with no data..

Thanks for getting back ...

what does the "other" do ?

so what happens if the date is 1/1/2012 and
there is no data for that date , that's the date I want to show ..
if 1/2/2012 has data I don't want to show it...

Thanks



Edited by jbalbo - 01 Feb 2012 at 2:50am

some people use (or create) a source table that is basically just a calendar, one row per calendar day. You can then outer join your data to this table to inlcude in the missing days.