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 ...

Hi

Still i am getting row wise only

thanks

sthanika