My colleague is asking me why the below works ?

Interestingly, if i specify the insert for just one customer ie 8458923, it is correct every time. (so the order by...

Once again, thanks for your reply. The query was sent to me by another team member who was doing it this way. I personally said to group by the customer...

All,

Thanks for the replies but i am still at a loss here. Let me explain further and simplify the query and exactly what i am trying to do. I know...

Excuse my ignorance, could you explain to me what you mean by an order by on the select statement please ?

Why does this work in 2000 though ??

Thanks In Advance

Lee