Select From XML

new_gist_file

public GetTests  (string[] test )
{

Var TestResults =  new XElement ("Tests"
                                 , test.Select (p => new XElement ("Test"
                                                                    , new XAttribute("TestId",p)
                                                                    )
                                                )
                                )
} 

XML.sql

@TestResults  XML = Null 


CREATE TABLE #Test 
{
   TestId  INT 
}

INSERT INTO #Test(TestId)
SELECT c.value ('@TestId[1]' , 'INT' ) AS TestId 
-- Adding second node ,
--  c.value ('@TestId[1]' , 'INT' ) AS TestId 
FROM @TestResults.nodes('/Tests/Test') AS P(c)