Hi, here are some links where I wrote about this:

http://www.setfocus.com/TechnicalArticles/Articles/sql-server-2005-tsql-3.aspx (go down to section 5....this converts a CSV to a table variable for subsequent join operations)


http://www.code-magazine.com/Article.aspx?quickid=0709031 (listings 12 and 13....this converts an XML string to a table variable)



Finally, I wrote about using the new table type in 2008 to pass a datatable as a parameter

http://www.code-magazine.com/Article.aspx?quickid=0807041 (Tip #5)