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

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

 

You may refer to http://forum.hkedcity.net/viewthread.php?tid=118127

 

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.

 

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

 

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.

 

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.