How the SQL Syntax for This Output

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

How the SQL Syntax for This Output

Author

Topic

indr4w
Starting Member

27 Posts

Posted - 2013-05-14 : 05:18:47

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

52326 Posts

Posted - 2013-05-14 : 05:28:49

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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-14 : 07:17:46

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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-20 : 01:22:49

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources