Recent content by lvg3401

Thanks for all the help and suggestions guys, much appreciated! Well, after sleeping on the problem I have tackled it from another angle today and here's my solution: First step was to add an index (auto number) to the table, and because my import routine pulls in all the data for each ticker...

I believe I just need to add an Order by some where in the above code to get the latest records, just not figured out quite where yet...

Update: Ok, using this site : http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ And using this example: select type, variety, price from fruits where ( select count(*) from fruits as f where f.type = fruits.type and f.price < fruits.price ) <= 2...

Sorry mate, I really wasn't directing that at you at all..! I thought you had just miss-understood what I was asking for. I honestly didn't mean to offend in any way. I actually meant that the only way that I could solve the problem was with the really stupid and in effective method of union...

Thanks for the link Paul, cant try it now until im back at work tomorrow..

But wont that just bring back the last 200 records for JJB? I need it to bring back the last 200 records for each Ticker (100+) The obviously stupid approach could be to create one of those for each Ticker and Union them together, but I dont feel that would be the most effective method of...

Yeah sorted by date, latest first. *Bow's head in shame* yes it was called Date but its now TickerDate :) Aje - I think you're right but the solution still eludes me

Thanks rainman i'll have a look through!

Hi Guys Should be a simple one this, but I just cant get my head round it.. Simple table in the format: Ticker___ Date___ Close JJB.L _08/04/2009 13.5 JJB.L _07/04/2009 12.75 JJB.L _06/04/2009 11 JJB.L _03/04/2009 10.75 JJB.L _02/04/2009 11 JJB.L _01/04/2009 10.75 JJB.L _31/03/2009 11.25...