Ninja's_RGR'us (6/1/2011)

---

SELECT

T.name,

STUFF((

SELECT

...

Jeff - I am very interested in an RBAR-less solution

Declare @InFoodID int

SET @InFoodID = 2

SELECT

AnimalFood.FoodID, Animal.AnimalName

FROM

AnimalFood INNER JOIN

Animal ON AnimalFood.AnimalID = Animal.AnimalID

WHERE

(AnimalFood.FoodID...

Mister Sachmo,

Also, yes I wanted to allow for #3 Duck, because it might come back in season.

The while works, but I am interested in something with the best...

Thanks Mister Sachmo (& I did make a mistake on the Chicken & Turkey examples).