Question: Let's say I have these values in a table

```
| Start Date              | End date                   |Other Value
---------------------------------------------------------------------
| 2015-01-07 01:00:00.000 | 2015-01-08 04:00:00.000    | Yes
| 2015-01-08 10:00:00.000 | 2015-01-10 20:00:00.000    | No

```

I want to write a select statement that should give me results like:

```
|Date        | Start Date   | End date     |Other Value
-----------------------------------------------------------
|2015-01-07  | 01:00:00.000 |              | Yes
|2015-01-08  |              | 04:00:00.000 | Yes
|2015-01-08  | 10:00:00.000 |              | No
|2015-01-10  |              | 20:00:00.000 | No

```

Is there a way to do it in T-SQL? 

I am using SQL Server 2008 R2.

Answer: 
Actually I was using Hibernate 5 jars . But the tutorial is actually for Hibernate 4. When I used Hibernate 4 jars everything seems to working fine.
May be you don't need `<mapping resource="com/simpleprogrammer/User.hbm.xml" />`. Instead, try `<mapping resource="User.hbm.xml" />`