I have a view with employee type history.
EmployeeID | EmployeeTypeTit le | EmployeeStartDa te
1 | trial | 2007-09-01
1 | regular | 2008-03-01
2 | trial | 2007-11-01

But now I need the data in a different format, with every month on a single row. Like this
EmployeeID | Period | EmployeeTypeTit le
1 | 200709 | trial
1 | 200710 | trial
1 | 200711 | trial
1 | 200712 | trial...