Problem Between Office HR and Me

Our Office got fully freedom Since before I join. From Start on Last week. HR ask me to give them attendence filter file between 7AM-10AM and 12AM-3PM. Actually they have online report system. They are really lazy to check manually. It makes me V.Troublesome. I only know Just Excel filter function. May be Ok with MS Accesss. But I don't know It has Transformation Service or not. That's why No way to use MS Access. I have to use SQL. No experience on SQL at all. That's why I m doing KwiSiKwaSi to my SQL experts frds. ehhehe


DBA man says I need three steps


1)transfer data from txt to sql table

2)make a query what you want to

3)make jobs to run that query everyday in sql server


Though he says Ideas what I have to do, I'm still confused in it. That's why I've asked his idea to his frd SQL expert for Step 1 and Step 2. She solved successfully. Thanks a million to DBA and KMT. Right now i'm in third Step.KMT escalated this case to DBA again. I have to wait Mr. DBA for that issue. As for me,I'm still reading hehehe













Above is my testing. I've to wait and see tomorrow if it will run or not. Let's see .