Hi
I tried with you example and i am getting the following result
1012000-01-01 00:00:00.000YNNN
1012000-01-01 00:00:00.000NYNN
1022001-01-01 00:00:00.000YNNN
1022001-01-01 00:00:00.000NYNN
1022001-01-01 00:00:00.000NNYN
1022001-01-01 00:00:00.000NNNY
1032002-01-01 00:00:00.000NNYN
1032002-01-01 00:00:00.000NNNY
1042003-01-01 00:00:00.000YNNN
but my resultset should be like
101 2000-01-01 Y ...