失聲記

Mon, 09 Nov 2009 13:48:14 GMT

喉嚨痛聲都失埋好痛苦@@
Oh My God

四代香港人

Wed, 14 Oct 2009 15:06:24 GMT

http://xiaoshousha.blogspot.com/2009/08/blog-post.html

記低這一晚

Sun, 13 Sep 2009 12:19:21 GMT

Imperial Ice Star

http://www.imperialicestars.com/

http://www.fotop.net/DonaldChin/Cinderella_On_Ice

限期

Sun, 02 Aug 2009 13:46:47 GMT

http://hk.myblog.yahoo.com/waibik

如果你已知道限期你會更加珍惜嗎?

Let 's Crazy

Sat, 25 Jul 2009 07:30:56 GMT

/* Start JOB */
SELECT CURR.EMPLID
, CURR.EMPL_RCD
, CURR.EFFDT
, CURR.EFFSEQ
, CURR.C_POST_TITLE
, (
SELECT MIN(T.EFFDT)
FROM PS_JOB T
WHERE T.EMPLID = CURR.EMPLID
   AND T.EMPL_RCD = CURR.EMPL_RCD
   AND T.C_POST_TITLE = CURR.C_POST_TITLE
   AND T.EFFDT > NVL(PRE_JOB.PRE_POST_EFFDT, TO_DATE('1990-01-01','YYYY-MM-DD'))
   AND T.EFFDT < NVL(POST_JOB.NEXT_POST_EFFDT, TO_DATE('9990-12-31','YYYY-MM-DD')) ) "CURR_POST_STARTDT" , POST_JOB.NEXT_POST_EFFDT - 1 "CURR_POST_ENDDT" , PRE_JOB.PRE_POST_EFFDT, PRE_JOB.PRE_POST, POST_JOB.NEXT_POST_EFFDT, POST_JOB.NEXT_POST
FROM PS_JOB CURR LEFT OUTER JOIN /* ------- BEGIN Pre Job TABLE */ (
SELECT B.EMPLID
, B.EMPL_RCD
, B.EFFDT
, B.C_POST_TITLE
, B.PRE_POST_EFFDT
, A.C_POST_TITLE "PRE_POST"
FROM PS_JOB A
, (
SELECT JOB1.EMPLID
, JOB1.EMPL_RCD
, JOB1.EFFDT
, JOB1.C_POST_TITLE
, MAX(PRE_POST1.EFFDT) PRE_POST_EFFDT
FROM PS_JOB JOB1
, PS_JOB PRE_POST1
WHERE PRE_POST1.EMPLID = JOB1.EMPLID
   AND PRE_POST1.EMPL_RCD = JOB1.EMPL_RCD
   AND PRE_POST1.C_POST_TITLE <> JOB1.C_POST_TITLE
   AND PRE_POST1.EFFDT < JOB1.EFFDT
   AND PRE_POST1.JOB_INDICATOR = JOB1.JOB_INDICATOR
   AND PRE_POST1.JOB_INDICATOR = 'P'
GROUP BY JOB1.EMPLID, JOB1.EMPL_RCD, JOB1.EFFDT, JOB1.C_POST_TITLE ) B
WHERE A.EMPLID = B.EMPLID
   AND A.EMPL_RCD = B.EMPL_RCD
   AND A.JOB_INDICATOR = 'P'
   AND A.EFFDT = B.PRE_POST_EFFDT
   AND A.EFFSEQ = (
SELECT MAX(T.EFFSEQ)
FROM PS_JOB T
WHERE A.EMPLID = T.EMPLID
   AND A.EMPL_RCD = T.EMPL_RCD
   AND A.EFFDT = T.EFFDT
   AND T.JOB_INDICATOR = 'P' ) ) PRE_JOB /*------- END Pre Job TABLE */ ON CURR.EMPLID = PRE_JOB.EMPLID
   AND CURR.EMPL_RCD = PRE_JOB.EMPL_RCD
   AND CURR.EFFDT = PRE_JOB.EFFDT
   AND CURR.C_POST_TITLE = PRE_JOB.C_POST_TITLE LEFT OUTER JOIN /*------- BEGIN NEXT Job TABLE */ (
SELECT B.EMPLID
, B.EMPL_RCD
, B.EFFDT
, B.C_POST_TITLE
, B.NEXT_POST_EFFDT
, A.C_POST_TITLE "NEXT_POST"
FROM PS_JOB A
, (
SELECT JOB1.EMPLID
, JOB1.EMPL_RCD
, JOB1.EFFDT
, JOB1.C_POST_TITLE
, MIN(NEXT_POST1.EFFDT) NEXT_POST_EFFDT
FROM PS_JOB JOB1
, PS_JOB NEXT_POST1
WHERE NEXT_POST1.EMPLID = JOB1.EMPLID
   AND NEXT_POST1.EMPL_RCD = JOB1.EMPL_RCD
   AND NEXT_POST1.C_POST_TITLE <> JOB1.C_POST_TITLE
   AND NEXT_POST1.EFFDT > JOB1.EFFDT
   AND NEXT_POST1.JOB_INDICATOR = JOB1.JOB_INDICATOR
   AND NEXT_POST1.JOB_INDICATOR = 'P'
GROUP BY JOB1.EMPLID, JOB1.EMPL_RCD, JOB1.EFFDT, JOB1.C_POST_TITLE ) B
WHERE A.EMPLID = B.EMPLID
   AND A.EMPL_RCD = B.EMPL_RCD
   AND A.JOB_INDICATOR = 'P'
   AND A.EFFDT = B.NEXT_POST_EFFDT
   AND A.EFFSEQ = (
SELECT MIN(T.EFFSEQ)
FROM PS_JOB T
WHERE A.EMPLID = T.EMPLID
   AND A.EMPL_RCD = T.EMPL_RCD
   AND A.EFFDT = T.EFFDT
   AND T.JOB_INDICATOR = 'P' ) ) POST_JOB ON CURR.EMPLID = POST_JOB.EMPLID
   AND CURR.EMPL_RCD = POST_JOB.EMPL_RCD
   AND CURR.EFFDT = POST_JOB.EFFDT
   AND CURR.C_POST_TITLE = POST_JOB.C_POST_TITLE /*------- END NEXT Job TABLE */
WHERE CURR.JOB_INDICATOR = 'P'
ORDER BY CURR.EMPLID, CURR.EMPL_RCD, CURR.EFFDT /*----- END JOB*/

怎樣才算一個家?

Fri, 24 Jul 2009 04:29:24 GMT

http://hk.news.yahoo.com/article/090722/4/dbb6.html

工作生活

Sun, 05 Jul 2009 04:18:00 GMT

2009-07-03
上午幫user對報report,圈埋邊到錯,下午同user一齊睇點改正data.開左四個鐘會user一句唔知點改.我地又要開多個場倒多次data, 個project又要delay多一個月,個種無得出聲無人撐孤掌難鳴的心情....唉, 我做o既野好似白費左無結果.好唔開心. 仲要因為個會搞到我拎唔到部相機.....><...
無人明白,在此發洩

kent0712's Xanga

芝士淺談

失聲記

四代香港人

記低這一晚

限期

Let 's Crazy

怎樣才算一個家?

網球王子

工作生活

HOME

kent0712's Xanga

芝士淺談

失聲記

四代香港人

記低這一晚

限期

Let 's Crazy

怎樣才算一個家?

網球王子

工作 生活

HOME

工作生活