Just did found a few odd results. Again thanks.

Thanks Very much for the help Grant you have defiantly pointed me in the right direction. I was almost there but it was one were i was heading down...

I have got it working now. Thanks to all for there help. :-):-)

Jason-299789 (10/30/2012)

---

heres a quick and dirty way

CREATE Table #results

(

RecordId Int

,ItemId Int

,cost Decimal(38,2)

)

Insert into #results

values (43392, 3880 ,50.00)

,(39056, 3881, 93.75)

,(33941, 3881, 97.50)

,(33970, 3881, 97.50)

,(38950,...

Current Data:

RecordIDItemIDMaxOfCost

433923880 $50.00

390563881 $93.75

339413881 ...

What is DDL and DML?

Sorry for the confusion but what I’m trying to do is to search each line and look at Product Code first then look at all line with same Product Code...

That worked Thank you very much :w00t:

Sorry but it does not seem to work. Just to clarify The [Product Code] is the '1001' number and the [Description] is 'Item 1 XX Large' not...

Paul

Worked well Thanks for the help. 😀