Hi,
From the below table data i was checking for smaller Service ID appears after higher Service ID numbers, it should display as NO in Sevice ID Seq. column and also without Service ID numbers also should be seen as 'No' in the Sevice ID Seq. column.
UUID | Service ID | End Date | Sevice ID Seq. |
1 | 18109187264 | 06/03/2017 | Yes |
2 | 18109187264 | 06/03/2017 | Yes |
3 | 18109187232 | 06/05/2017 | NO |
4 | 18109187312 | 06/05/2017 | Yes |
5 | 18109187314 | 06/05/2017 | Yes |
6 | 18109187315 | 06/05/2017 | Yes |
7 | 18109187313 | 06/05/2017 | NO |
8 | 18109187316 | 06/05/2017 | Yes |
9 | 18109187317 | 06/05/2017 | Yes |
10 | 06/05/2017 | NO | |
11 | 06/05/2017 | NO | |
12 | 18109187320 | 06/05/2017 | Yes |
13 | 18109187321 | 06/05/2017 | Yes |
14 | 18109187265 | 06/05/2017 | NO |
15 | 18109187267 | 06/05/2017 | NO |
16 | 18109187324 | 06/05/2017 | Yes |
Thanks
Solved! Go to Solution.