Hi.
I want to pass a Table of Primary keys to a stored procedure, with the intention of selecting out ALL children related to All the Rows passed into the SP.
Something Like following in Stored Procedure:

Select * from @ParentTable join ChildTable on ParetPK = ChildFK

Just wondering is it possible to pass the ParentTable as a parameter to the Stored Procedure. Code examples would be appreciated
The ParentTable is the Parameter I want to Pass in
ChildTable is a SqlServer Table in a database

Tia
Gerard