Frank

Thank you very much!

That was just exactly what I was looking for. I new there is simple solution and u've show it to me.

Thanks

Bose

Thanks for replay

If I'm right select top 1 id, amount, date will return only 1 record. I need 3 records to be returned. I need amount of the most...

Thank you every one for replayed. Becouse I have to do this within ASP, I don't have DTS and I am not very familiar with DTS objects to work them...