then either build the statement by way of a program like a perl script or select all records with a start time after the min start time of all in your list and an end time less than the max end time in your list then filter them further either in a program or a store procedure.
On Fri, May 8, 2009 at 11:45 AM, Abhishek Pratap <abhishek....@gmail.com>wrote: > Hi Jim > > Unfortunately I have thousands of such points. So explicit statement > calling will be very expensive both computationally and in terms of > writing.. > > Thanks, > -Abhi > > > On Fri, May 8, 2009 at 12:37 PM, Jim Lyons <jlyons4...@gmail.com> wrote: > >> why not something like below. Assume you have 3 pairs of start/end >> timestamps and you want to find everything within those 3 time periods: >> >> select * from table_name where start >= start1 and end <= end1 >> union >> select * from table_name where start >= start2 and end <= end2 >> union >> select * from table_name where start >= start3 and end <= end3 >> >> >> On Fri, May 8, 2009 at 11:26 AM, Abhishek Pratap >> <abhishek....@gmail.com>wrote: >> >>> Hi All >>> >>> I am kind of stuck with this query , cant expand my thinking. May this >>> is a >>> limitation. Here it is >>> >>> I have a database with many cols two of which are start and end position >>> for >>> an event. >>> >>> Now I have a list of event time stamps, I want to find all the info once >>> the >>> current event time stamp is >= start time of event and <=end time of >>> event. >>> >>> something like this >>> >>> select * from table_name where start <= ( LIST of time stamps) AND end >>> >=( >>> list of time stamps). >>> >>> Clearly above query accepts only one item in the list. Is there a way to >>> do >>> this for multiple items in the list ??? I can't think of anything at this >>> moment. >>> >>> >>> Thanks, >>> -Abhi >>> >> >> >> >> -- >> Jim Lyons >> Web developer / Database administrator >> http://www.weblyons.com >> > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
