SQL 如果抽取每個教職員一個月裡之請假紀錄?

本文由 - 在 2014-04-15 發表於 "WebSAMS 討論區" 討論區

  1. Expand Collapse

    can provide sql code to extract such data? (the date of leave for each staff)
    thanks
     
  2. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
  3. Expand Collapse

    i got this error when i copy the sql from the thread given.
    Is anything that I need to pay attention to?
    thanks
    E-16053 : SQL Statement is empty or invalid.
     
  4. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
    I tried to copy and paste the SQL from the thread and I got a lot invalid characters. I think that's the cause of the error. So, I saved the SQL in a Word doc. Pls try again.

    瀏覽附件staff_leave.zip
     
    #4 edb-石頭, 2014-04-28
  5. Expand Collapse

    thanks for help
    at the beginning I also deleted the invalid characters but i got the error msg.
    but now i still got the same error when I used the code from the word file.
     
  6. 56953375

    edb-石頭
    Expand Collapse

    文章:
    1,160
    讚:
    0
    I tried the SQL again and i was able to extract the data. Pls contact your school liaison officer. I need more info for investigation.
     
    #6 edb-石頭, 2014-05-12