This doesn't sound too bad but there is really nothing anybody can do to help based on the limited details you have posted. Are you looking for specific query assistance or just general guidelines on how to do this? Either way you need to help us understand the problem. The easiest way for that is to post ddl, sample data, and desired output based on the sample data. See the first link in my signature for best practices when posting questions.