dcsimg
Results 1 to 2 of 2

Thread: Please help ... SQL query

  1. #1
    Join Date
    Apr 2011
    Posts
    1

    Please help ... SQL query



    ----

    From the HISTORY table we want to Fetch data that is 3 days prior to and 3 days after each of the EVENT_D We do not want the repeat history if the Incident_day events make this data overlap.

    EX. Incident-date = 2/18/2011 3 days prior is 2/15 3 days after is 2/21
    Incident-date = 2/202011 3 days prior is 2/17 3 days after is 2/23

    In this case the data from 2/18 2/21 would be repeated. Only show that once, the Fetch should get the data from 2/15 2/23.


    ---- can you please help me in writing the query ..

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,911
    Can you clarify further with table definition. What are you trying to select? Is there more than one condition in the query?, how are two incident_involved?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •