Sql Query - SQL Server Forums

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources