Is this what you are looking for:
DECLARE @xml XML =
( SELECT * FROM OPENROWSET(BULK 'C:\temp\test.xml', SINGLE_BLOB) AS data)
SELECT @xml c1 INTO ttt
select c1 FROM ttt
SELECT
c.value('@internalid', 'nvarchar(max)') as id,
c.value('@name', 'nvarchar(max)') as name
,c.value('(summary/text())[1]', 'nvarchar(max)') as summary
,c.value('(importance/text())[1]', 'nvarchar(max)') as importance
,c.value('(steps/step/step_number/text())[1]', 'nvarchar(max)') as step
,c.value('(steps/step/actions/text())[1]', 'nvarchar(max)') as stepaction
,c.value('(steps/step/expectedresults/text())[1]', 'nvarchar(max)') as expectedResult
FROM ttt
CROSS APPLY c1.nodes('/testsuite/testcase') AS T(c)
go
DROP TABLE ttt
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]