asked
transform data rows into data ranges
Hello, I have employee data in the attached table 1![alt text][1] I would like to have final out like like in the attached table2 ![alt text][2] This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same. Thank you for help! [1]: /storage/temp/3492-table1.png [2]: /storage/temp/3493-table2.png
If you're on SQL 2012 or later you can use the LEAD() function to get at the date from the following line.
Thank you for answer I have managed to do that via LEAD and LAG functions.
18 People are following this question.
