SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How the SQL Syntax for This Output
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

indr4w
Starting Member

Indonesia
27 Posts

Posted - 05/14/2013 :  05:18:47  Show Profile  Reply with Quote
Emp No. AC-No. No. Name Auto-Assign Date Timetable On duty Off duty Clock In Clock Out Normal Real time Late Early Absent OT Time Work Time Exception Must C/In Must C/Out Department NDays WeekEnd Holiday ATT_Time NDays_OT WeekEnd_OT Holiday_OT
156 1080112 00204 INDRA WIJAYA 02/05/2013 NON SHIFT 07:00 16:30 07:02 16:39 1 1 00:02 09:28 True True IT 1 09:37
156 1080112 00204 INDRA WIJAYA 03/05/2013 NON SHIFT 07:00 16:30 06:58 16:50 1 1 00:20:49 09:30 True True IT 1 09:52 0,35
156 1080112 00204 INDRA WIJAYA 04/05/2013 SABTU-MINGGU 07:00 07:01 06:56 16:42 1 1 09:41:25 00:01 True True IT 1 09:46 9,69
156 1080112 00204 INDRA WIJAYA 06/05/2013 NON SHIFT 07:00 16:30 06:54 18:26 1 1 01:56:57 09:30 True True IT 1 11:32 1,95
156 1080112 00204 INDRA WIJAYA 07/05/2013 NON SHIFT 07:00 16:30 06:54 18:10 1 1 01:40:13 09:30 True True IT 1 11:16 1,67
446 22555 00256 AMINUDIN 02/05/2013 NON SHIFT 07:00 16:30 06:50 16:39 1 1 09:30 True True IT 1 09:49
446 22555 00256 AMINUDIN 03/05/2013 NON SHIFT 07:00 16:30 06:44 16:48 1 1 00:18:35 09:30 True True IT 1 10:04 0,31
446 22555 00256 AMINUDIN 04/05/2013 SABTU-MINGGU 07:00 07:01 06:33 16:42 1 1 09:41:21 00:01 True True IT 1 10:08 9,69
446 22555 00256 AMINUDIN 06/05/2013 NON SHIFT 07:00 16:30 07:00 16:45 1 1 00:15:05 09:30 True True IT 1 09:45 0,25
446 22555 00256 AMINUDIN 07/05/2013 NON SHIFT 07:00 16:30 06:44 18:10 1 1 01:40:03 09:30 True True IT 1 11:25 1,67
446 22555 00256 AMINUDIN 08/05/2013 NON SHIFT 07:00 16:30 06:44 16:44 1 1 09:30 True True IT 1 10:00

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/14/2013 :  05:28:49  Show Profile  Reply with Quote
without any details on tables, relationship etc nobody will be able to suggest on anything.
Follow the link below and understand how to post the data to get quick and accurate help

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/14/2013 :  07:17:46  Show Profile  Reply with Quote
Check the link and post sample data from tables and explain what you want from them as output. Just posting table ddl will not help

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/20/2013 :  01:22:49  Show Profile  Reply with Quote
My suggestion was not to post entire db here

Please post some indicative data to highlight your issue and show us what you expected out of it as output

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000