Hello,

Now I understand it completey and all makes sense to me. Looks like I have to use the OrderBy Clause.

Thanks a lot for the detailed explanation. Cleared my basics.

Snigdha

Hey,

Thanks a lot...

This is exactly wht I was looking for. Now I am right on target.

Snigdha

Hey,

Never thought of triggers..hmm seems to be a good idea. I think I will go ahead and try the trigger option.

Thanks,

Snigdha

Wowww...

this was really clear..I got the entire thing. I think it was something like this I was looking for.

I will implement it right now....

thanks a looot.

Snigdha

Thanks,

I will look into that and come back if problem persists.

Snigdha

Hi,

This was right on target !!!!

The output is exactly in the way I wanted it.

Thanks a lot !!!

Snigdha

Hi,

Let me explain a little further...

The point is that there are matching records.

The Project table has a list of Projects and each TestRequest in the TestRequest table is...

Hi,

This not only helped, but was exactly what I wanted. I mimplemented it with very minor changes and my code is working so perfect.

Thanks a lot once again for the...

hey..

thank a lot, all my queries resolved.

Snigdha

The above query returns the last record of the last TestRequestNO. But I wanted to the last record of each TestRequestNO. For e.g.:

TestRequestNo  TestRequestStateId

TR123  11

TR123  3

TR123  5

TR123  12

TR155  11

TR155  3

TR155  5

TR007  11

TR007  12

TR007  3

Now, out of this orderd set of...

I forgot to mention one more condition...

My first Select gives me a set of records, I need to order them onthe TestRequestNo and then take the last of all the...

wow...

that was the easiest way to do. It was so easy that i took some time to understand it..)

Thanks a lot,

Snigdha