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