SQL Query

Dear,
I agree to chris, the best thing to do is add a column of TranType based on whichu can get the desired results without much pain and not lot of time will get saved. :)

CHRIS:
I got your point regarding ORDER BY. And I am 100% agree with your point. I am really sorry that I could understand your technical point little late but infect it was really deep and dark for me that why I have to use ORDER BY. Actually your last reply help me a lot because of you query with illustration & demonstration. This is what I was expecting from you to show me technically not by text writing.

I appreciate for this help. I totally understand you have spend a lot of time to help me resolve this critical issue. I am going to change my query and will see the results in report.

ALES where are you? I thankful to your initial solution.
CHRIS I am very glad about your time and technical material, which you spend and deliver a solution.
VIJAY I also like your idea but some conditions apply and I can not add new column it is not in my hand.

Once again thanks
aph.

Hi,
nice to read I helped you, aph.
To be honest, I posted my solution although I couldn't see any practical purpose of it.
If I knew what your real problem was I'd suggest a different solution.
This time you were lucky and this simple one was good enough ;-)).

Hat off to you, Chris.
Excellent knowledge, great patience, clear language. These are things I like this forum for.

Have a nice time!

Ales