Does the varray or/and nested table mechanism exists in sql server

Hi.

Like in subject. I know the varray and nested tables from oracle, and I'm trying to implement them in sql server. I've been googling for any information but with no result. Can somebody direct me ??

Sorry for any english mistakes

Thanks for help

Hello,

I'm not familiar with those objects in Oracle, but if in SQL Server 2005 you want to use these in a query or proc, you need to lookup table variables, temp tables, or new to 2005 common table expressions.

If you are looking to do something else, let me know.

|||

I'm trying to do something like thisplease see the image. Project and Task_types are tables. Each project has his own Task_types table I want to do this by defining one of the project collumns as a table(or varray), is this possible to do in sql server ? or maybe there's other way to do this ?

Sorry for possible English mistakes

Thanks for your help