When I try to create a stored procedure reading xml data using your example I get

and error on the select portion

it says "Cannot find either column "C" or the...