Should I have an output parameter then? I declared one.. @status int out.

When I execute the SP from SS2008, it gives two results - @status - 0 ; Return Value...

Thank you, but mentioning the childtable explicitly is not an option here. A parent table can have many child tables.