I have one table with name "Employee"...It has 3 fields:

1. empid
2. from date
3. todate

I want to split the period of date (dates between *from date* & *to date* including both) for the corresponding *emp id*.

For example here's the table I've got:

```
emp id        from date          to date
  1           1/1/2011           3/1/2011
  2           5/1/2011           5/1/2011

```

From that I'm want to get this:

```
1         1/1/2011
1         2/1/2011
1         3/1/2011
2         5/1/2011

```

What's an SQL query that would do this for me?