lists in stored procedure

[Msabry]

Hi,
I am trying to write a stored procedure that would do something like this
create proc test
@category int,
@itemList varchar(100)
as
begin
set @itemList='select itemID from table.items where category=@category'
EXEC sp_executesql @itemlist

select * from table.itemdesc
where itemId in (@itemlist)
end
go

so the idea, is to get all the rows in the table that meet a certain
constraint, pass the id's of those rows to another query that would get the
info for the specific item.

I also need to find out how to make the query loop over a list of inputs and
return the relevant data,
thanks

[PaulH *ACE*]

why bother w/a list & all that:

SELECT *
FROM table.itemdesc
WHERE itemId IN
(
SELECT itemID
FROM someTable.items
WHERE category=@category
)


or do a JOIN or use EXISTS