Before we start this is not my database....
We have a Time and Attendance System that stores all the clockings in seperate tables depending on the year and month i.e.
DT102006 = Oct 2006
DT112006 = Nov 2006
What I am trying to achieve is to extract out of the tables certain information and import it into another database to do with employment law so we can analyis absences....
so
month = 11
year = 2006
select * from DT+month+year
Did that make sense ?
We have a Time and Attendance System that stores all the clockings in seperate tables depending on the year and month i.e.
DT102006 = Oct 2006
DT112006 = Nov 2006
What I am trying to achieve is to extract out of the tables certain information and import it into another database to do with employment law so we can analyis absences....
so
month = 11
year = 2006
select * from DT+month+year
Did that make sense ?