SLP Request for SQL of all S4-6 students OLE records and performance outside school

本文由 Canyon 在 2012-01-03 發表於 "WebSAMS 討論區" 討論區

  1. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0
    Dear all,

    I want to extract from WebSAMS by SQL

    1) all S4-6 OLE records.
    2) all S4-6 performance outside school.

    Thank you!
     
  2. 56424333

    edb-stsim2
    Expand Collapse

    文章:
    258
    讚:
    0
    Please refer to here.
     
    #2 edb-stsim2, 2012-01-03
  3. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0
    Sorry, what I want is the SQL really extracting
    1) all S4-6 OLE records.
    2) all S4-6 performance outside school.

    in the module SLP, is it possible?
     
  4. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
    Pls try the below SQL, they extact data from SLP module only.

    1)
    SELECT
    a.schyear,
    a.classlvl,
    a.CLASSCODE,
    a.CLASSNO,
    a.chname,
    a.ENNAME,
    b.STARTYR,
    b.ENDYR,
    b.PROG_ENG,
    b.PROG_DESC_ENG,
    b.ROLE_ENG,
    b.ORG_ENG,
    b.AWARD_ENG,
    b.MAJOR_ENG,
    c.seq
    FROM TB_SLP_STU_OLE_FROMSLP b, VW_STU_LATESTSTUDENT a, TB_SLP_OLE_SEQ c
    WHERE a.STUID = b.STUID and b.stuid = c.stuid and b.ole_id = c.code_id and c.tb_id = 'SLP' and a.schyear=?
    ORDER BY 2,3,4

    2)
    select
    d1.schyear,
    d1.classlvl,
    d1.classcode,
    d1.classno,
    d1.chname,
    d1.enname,
    c1.STARTYR,
    c1.ENDYR,
    c1.PROG,
    c1.PROG_DES,
    c1.ROLE,
    c1.ORG,
    c1.AWARD,
    c1.SEQ
    from TB_SLP_STU_PERFME_OUTSCH c1
    join vw_stu_lateststudent d1
    on c1.suid=d1.suid and c1.stuid=d1.stuid
    where d1.schyear=?
    order by 2,3,4
     
    #4 edb-石頭, 2012-01-05