SQL 2008 Script for converting vertical to horizontal
===

I am a new in SQL, Pleasae help me how can i convert it into horizontal
Example:

 (Old)

 No	Mchn	EnNo		Name	       DateTime	
00001	1	01110037	Juan      2012/07/16  08:00:18
00002	1	01110037	Juan      2012/07/16  12:02:23
00003	1	01110037	Juan      2012/07/16  12:42:23
00004	1	01110037	Juan      2012/07/16  18:42:23
00005	1	01110038	Robert    2012/07/16  08:00:18
00006	1	01110038	Robert    2012/07/16  12:02:23
00007	1	01110038	Robert    2012/07/16  12:42:23
00008	1	01110038	Robert    2012/07/16  18:42:23



Result that i want to show..

   (New)

 EnNo         Name       Date            TimeIn          BrkIn       BrkOut     TimeOut
01110037     Juan	2012/07/16	08:00:18	12:02:23     12:42:23	18:42:23
01110038     Robert	2012/07/16	08:00:18	12:02:23     12:42:23	18:42:23 