so_damn_insane's Journal
 
[Most Recent Entries] [Calendar View] [Friends View]

Wednesday, November 7th, 2007

    Time Event
    10:55a
    Pasakiet, kāds, lūdzu - KĀDA VELNA PĒC TAS STRĀDĀ???!!!

    SELECT
    change_date AS change_date
    ,date_from AS date_from
    ,date_to AS date_to
    ,cgp_id
    FROM (select 1 as ctr_id
    ,to_date('20070101','yyyymmdd') as change_date
    ,to_date('20071106','yyyymmdd') as date_from
    ,1 as cgp_id
    ,null as date_to
    from dual
    ) cgp_new
    JOIN (select 1 as id, 'C' as code from dual) cgp
    ON (cgp_new.cgp_id = cgp.id)
    JOIN (select 1 as ctr_id
    ,to_date('20070201','yyyymmdd') as change_date
    ,to_date('20071106','yyyymmdd') as date_from
    ,2 as cgp_id
    ,to_date('20071105235959','yyyymmddhh24miss') as date_to
    from dual
    ) cgp_old
    ON ( cgp_old.ctr_id = cgp_new.ctr_id
    AND cgp_old.date_to = cgp_new.date_from - 1/(24*60*60) -- intervāli nepārklājas
    )
    JOIN (select 2 as id, 'D' as code from dual) cgp2
    ON (cgp2.id = cgp_old.cgp_id)
    /
    7:49p
    (ar priekšzināšanām)
    Atceroties, kā agrāk iekš slashdot un vēl šur tur citur tika analizēts, kas tad īsti ir "42", ienāca prātā, ka savā ziņā adekvāts jautājums tam varētu būt - "ko tie biči grib no tā nēģera?"

    << Previous Day 2007/11/07
    [Calendar]
    Next Day >>

About Sviesta Ciba