I found this screencast on MSDN’s Channel9, its a great addition to Simon’s post especially if you are a more visual person.

Table Valued Parameters