Hi,
I have a table that has the following str and data
ContainerID, ItemId, DateTime
2, 1, 06/23/2007
3, 2, 06/24/2007

So effectively speaking item 1 is in container 2 which is in container 3.

If I were to retrieve all the containers item 1 is in, what should be the query?
[I need both rows]

Thanks,

you need a recursive procedure

Hi asterix_thegaul,

Please check whether this query helps

declare @itemId as int
set @itemId=1
select ContainerId from table
where
itemId=@itemId
or
(itemid in (select containerid from table where itemid=@itemId))

Thanks and Regards,
Anju Renjith