Hi team, I have data in Note Pad. like these
LineNO EmployeeID StartDate EndDate BaseSalary
1 1.00 1/1/2008 00:00:00 31/12/2008 00:00:00 100000
2 1.00 1/1/2009 00:00:00 31/12/2009 00:00:00 110000
3 1.00 1/1/2010 00:00:00 31/12/2010 00:00:00 120000
4 1.00 1/1/2011 00:00:00 31/12/2011 00:00:00 130000
5 1.00 1/1/2012 00:00:00 31/12/2012 00:00:00 140000
6 1.00 1/1/2013 00:00:00 31/12/2013 00:00:00 150000
7 1.00 1/1/2014 00:00:00 160000
8 2.00 1/4/2010 00:00:00 31/12/2010 00:00:00 35000
I want output like these
LineNO EmployeeID StartDate EndDate BaseSalary
1 1.00 1/1/2008 00:00:00 31/12/2008 00:00:00 100000
2 1.00 1/1/2009 00:00:00 31/12/2009 00:00:00 110000
3 1.00 1/1/2010 00:00:00 31/12/2010 00:00:00 120000
4 1.00 1/1/2011 00:00:00 31/12/2011 00:00:00 130000
5 1.00 1/1/2012 00:00:00 31/12/2012 00:00:00 140000
6 1.00 1/1/2013 00:00:00 31/12/2013 00:00:00 150000
7 1.00 1/1/2014 00:00:00 160000
8 2.00 1/4/2010 00:00:00 31/12/2010 00:00:00 35000
Main problem at End Date and Salary. How can i solve this issue.
