Hi
I tried with you example and i am getting the following result
101 2000-01-01 00:00:00.000 Y N N N
101 2000-01-01 00:00:00.000 N Y N N
102 2001-01-01 00:00:00.000 Y N N N
102 2001-01-01 00:00:00.000 N Y N N
102 2001-01-01 00:00:00.000 N N Y N
102 2001-01-01 00:00:00.000 N N N Y
103 2002-01-01 00:00:00.000 N N Y N
103 2002-01-01 00:00:00.000 N N N Y
104 2003-01-01 00:00:00.000 Y N N N
but my resultset should be like
101 2000-01-01 Y ...