Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SqlSisir
Starting Member
2 Posts |
 Posted - 2008-12-18 : 01:59:51
|
| Hi i am new to this forum,Hope U will guide meMy Query is :For my application i want those employee details who are not present for min 2 satudays for a month and not in leave for the saturdaysi have employee details/Muster/Leave tableIn Leave table i have From Date and To Date of any leave approvedThanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-18 : 02:11:54
|
| what does master table contain? 1 record for each employee per day? |
 |
|
|
SqlSisir
Starting Member
2 Posts |
Posted - 2008-12-18 : 04:40:54
|
| In the tables - Emuster table contains sign in & sign out time for each employee per day - Leave table contains leave details(from date,to date,id) for each employee - Employee table contains employee details (employee id,name) for each employee |
|
|
|
|
|
|
sql query