Create a Temp table with exact structure of the xml
Open the xml document using sp_xml_preparedocument and then insert the data from xml into the temp table created above.
Once inserted removed the xml document using sp_xml_removedocument
exec sp_xml_preparedocument @hDoc OUTPUT, @xmlntextparameter
INSERT INTO @temptable(columns)
SELECT * FROM OPENXML(@hDoc, 'CC',2)
WITH ( Type varchar(10),Exp varchar(10),.....)
exec sp_xml_removedocument @hDoc