Getting the latest row from a batch - ping challenge Aaron

[Robbie]

Hi All

This is a belter that my little brain can't handle.

Basically I have 1 SQL table that contains the following fields:

Stock Code
Stock Desc
Reference
Transaction Date
Qty
Cost Price

Basically this table stores all the transaction lines of when a user
books stock items into stock so that they can look at a journal of
this goods in as and when they please.

My task is that the user wants a list of all the stock items with the
last cost price that they were booked in at.

So I think I have to find the last transaction date used for each
stock code and then bring this back as 1 row per stock code with the
above fields of data.

How the whats-its can I do this? Is it acutally possible?

Any help you can give is much appreciated.

Rgds

Laphan

[Aaron Bertrand - MVP]

"Robbie" <google@astraaccounts.co.uk> wrote in message
news:f588d13a.0312081049.2da74923@posting.google.c om...

> Hi All
>
> This is a belter that my little brain can't handle.

Arrgh! Please don't multi-post!!! I already answered this in another
group.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]