SQLServer2005 LARGE XML to Table Variable.

[TheCPUWizard]

I have a fairly large XML file (about 10,000 elements each with 5 sub elements). I would like to transfer this as a single parameter to a stored proceedure. Within the stored procedure I would like to be able to treat this data as if it was a table (or load it into a table variable).

I have done this in the past, but must be brain dead this (satuday) morning. If anyone has a link, I would appreciate it.