select 人名 from test where (sysdate - 起始日期) < 請假天數 3-1=2 < 5 在五天內=請假 根據不同SQ...
試 select a.id,a.name,a.start_date,a.end_date ,isnull((select '請假中' from test as...
試 select a.id,a.name,a.start_date,a.end_date ,isnull((select '請假中' from test as...
應該不必這麼麻煩才對.. Declare @Q_date = Convert(Date,'2012/12/03') Select * from Test Whe...
應該不必這麼麻煩才對.. Declare @Q_date = Convert(Date,'2012/12/03') Select * from Test Whe...