Passing and Receiving tables To/From SP

In MSSQL 2000, it was not possible to nest the passing and receving of resultset (table) to multiple nested levels. Is it possible in SQL Server 2005? If yes, please point me to some links confirming the same.

I have a partitioned database and i am accessing them through view. My queries on that view do not run (they give error) if it has more then 255 tables. Otherwise i am quite happy with the performance of my db. I just want to know if i can partition them further.

Frank,

The article by Erland is good but i have reservations regarding performance because of xml parsing and all. Let me see if i can find something else which is purely TSQL

Madhivanan,

I don't think my question really needs explanation on what i am doing here. I just need to pass and receive recordsets.

An year back i did a comparison between passing an array of values in a string (comma separated) versus passing them as an xml. xml approach was much slower then raw approach because of XML parsing involved.