Re: (OT) Complex SQL Statement

Really not the right place here, but OK. It would help to specify your db engine as well. It should go roughly like this:

select * from tbl 
where coalesce(actual_start, projected_start, some_deep_past) <= curre
+nt_date 
and coalesce(actual_finish, projected_finish, some_far_future) >= curr
+ent_date
[download]

Comment on Re: (OT) Complex SQL Statement Download Code

Replies are listed 'Best First'.
Re^2: (OT) Complex SQL Statement by massa (Hermit) on Jul 23, 2008 at 20:35 UTC
even clearer (IMHO) and shorter: `select * from tbl where current_date between coalesce(actual_start, projected_start, some_deep_past) and coalesce(actual_finish, projected_finish, some_far_future)` [download] []s, HTH, Massa (κς,πμ,πλ)	[reply] [d/l]
Re^2: (OT) Complex SQL Statement by Pancho (Pilgrim) on Jul 23, 2008 at 19:55 UTC
Ahh, the beauty of an elegant and concise solution...	[reply]
Re^2: (OT) Complex SQL Statement by boblawblah (Scribe) on Jul 24, 2008 at 15:23 UTC
THANK YOU!	[reply]