Use OpenXML on an Xml document with a default namespace

this is an interesting stuff

BEGIN

SET NOCOUNT ON;
declare
@XmlAddHandle int,
@XmlDeleteHandle int,
@xmlString varchar(max)

set @xmlString = '


e27b4a1b-3f75-44b2-9538-4acc108505d2
nokia 6280
In Work
child scenario
2008-08-23T00:00:00+05:30
planner
17bb0215-1daa-4195-96e2-9feeefecac73


e27b4a1b-3f75-44b2-9538-4acc108505d2
ed5c9c5e-5b59-49af-add2-d16a08b686df
2008-09-01T14:59:10.953+05:30

'

EXEC sp_xml_preparedocument @XmlAddHandle output, @xmlString,''

SELECT * FROM OPENXML(@XmlAddHandle,'//a:Scenario',2) WITH ([a:Status] varchar(20))


EXEC sp_xml_removedocument @XmlAddHandle

END