Lowell (8/6/2012)

---

what have you tried so far?

this kind of looks like homework, so I'd prefer to help you learn how, rather than throw an answer out there.

you have more than...

sorry,

I meant to reply to this one, yes I would use warehouseId as precedent for selection

Hello Lowell,

to answer your question, I have tried using a cursor to loop and do this, I was hoping to find a better solution.

yes I do have a orders...

yes