I am new in SQL, please 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

```