Thanks a lot. Exactly what I'm looking for. Much obliged!

Best

Nick

Thanks Simon! Much obliged. Think you gave me enough to get started.

Thanks to all for the help. This certainly gives me a leg up on tweaking a routine.

MUCH OBLIGED!!!

Thanks.

Replacing the app down the road may be an option however the existing data in this structure still needs to be dealt with in the meantime--if possible.

The first column relates...

Thanks guys.

I can say that the relationship between students, tests and results is deterministic according to the rowid. In other words, looping from top to bottom:

First loop would loop the...

Thanks. Will give this solution a go.

Much obliged!

Al

The W01 exam.

Most of the problem is face is because data is coming from a procedural type of application and the only to know how to group the results with...

Craig-

This works perfectly.

Was not familiar with "Cross Apply",

What would you see in the way of optimizations? Indexes on the "id"s on the Level tables?

Much obliged for your assistance.

Nick

Many thanks!!

Will give it a go!!

I luv this site!!

In retrospect I should have used "Condiments" instead of "Beverages" since they should join only to the "Food" items. So for instance, if you subsituted the "Coffee" and "Orange Juice"...

This:

SELECT 'MEAL',

F1.meal_seq AS meal_start_seq,

(MAX(F2.meal_seq)-1) AS meal_end_seq,

MAX(F1.item_descr) AS item_descr

FROM MealFlatFile AS F1

LEFT OUTER JOIN

MealFlatFile AS F2

ON F1.meal_seq < F2.meal_seq

GROUP BY F1.meal_seq;

Actually reutrns this:

(No column name)meal_start_seqmeal_end_seqitem_descr

MEAL113Happy Meal

MEAL513Big Breakfast

MEAL1213Fish Special

MEAL14NULLChicken Platter

Did...

The desired output was an inner join from Meals to Food and a left join from Food to Beverage.

This helps. Thanks.

Thanks.

Much appreciated.

Nick

Man, I feel like slime posting this but for its real, I'm taSked to solve it and for the life of me can't get started.

Even hints would help.

MUCH OBLIGED:-)

Thanks folks. VERY MUCH APPRECIATED for the assistance!

al