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)
 Sql Query

Author  Topic 

prakashuj
Starting Member

12 Posts

Posted - 2014-04-09 : 04:10:25
Dear All,

The have the data in the below format

Name Dept Punch Date Status
Robin Purchase 4/3/14 18:00 Out
Robin Purchase 4/3/14 17:57 In
Robin Purchase 4/3/14 15:04 Out
Robin Purchase 4/3/14 14:20 In
Alex Accounts 4/3/14 14:09 Out
Alex Accounts 4/3/14 14:07 In
Alex Accounts 4/3/14 10:53 Out
Alex Accounts 4/3/14 7:52 In

I need the query which gives the output in the below Format
Name Dept Punch Date Status
Robin Purchase 4/3/14 18:00 Out
4/3/14 17:57 In
4/3/14 15:04 Out
4/3/14 14:20 In
Alex Accounts 4/3/14 14:09 Out
4/3/14 14:07 In
4/3/14 10:53 Out
4/3/14 7:52 In

Thanks and Regards
Prakash

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-04-10 : 04:19:26
This is the formation issue which should be done in a front end application.

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -