Timeline for Get records between time span
Current License: CC BY-SA 2.5
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 4, 2011 at 9:12 | comment | added | Deeptechtons | i marked my answer as the "Answer" thanks for anyone and everyone who posted their views here. | |
| Feb 21, 2011 at 15:25 | comment | added | jcolebrand♦ | @Deeptechtons ~ So are you willing to accept this answer or would you prefer to post your own and mark it as accepted? | |
| Feb 21, 2011 at 12:46 | comment | added | Leigh Riffel | Sounds like you are essentially doing the same thing my query does just doing it in the front end rather than the SQL. | |
| Feb 21, 2011 at 12:01 | comment | added | Deeptechtons | Oops sorry guys i was on touring glad that many had updated the post. Simply said, i would filter the time span if it is Am / Pm at the front end [Presentation Layer] which would deduce to 0,1 or 2. Then on the dataaccess layer i do this NOT_AVL_FOR <> @FrontendParameter. Hence i get the staff who are available for the time slot to be assigned work. This might not fit your exact needs but most of times , frontend could answer complex queries if otherwise | |
| Feb 18, 2011 at 18:42 | history | answered | Leigh Riffel | CC BY-SA 2.5 |