January 7, 2014 at 3:44 pm
debajit (1/5/2014)
Hi Christian,Please help me to generate a Select query which can determine all Daily Schedules for current Day which might fall in any of Schedule Type and Due_Day.
Thanks,
Khanin
Based on this statement is why I looked at the Due_Day field and ignored the Schedule_Type.
I agree the Schedule_Type is useless for what is shown so far.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 7, 2014 at 3:47 pm
As far as I can see, the due day is either the starting day, or it's the next day, which is meant to be calculated, using that string value. Working out the next day based on that string is entirely the requested task.
I think everyone who is getting pulled in to this question is realising the same thing - this system is unworkable the way it's been designed, the broad variety of potential inputs needs to be standardised, put in it's own table or group of tables, and turned in to something it's possible to write reasonable SQL against.
January 7, 2014 at 3:55 pm
Christian Graus (1/7/2014)
As far as I can see, the due day is either the starting day, or it's the next day, which is meant to be calculated, using that string value. Working out the next day based on that string is entirely the requested task.
Could be, I read it as it was the day it was due.
I'm just going to wait until the requestor provides more info/feedback before I waist any more time on it.
Have a good one...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply