tsql - T-SQL: query xml with namespace -
i've done basic xml work in t-sql before, literally 'basic'. now come across more complex xml , flummoxed begin. <?xml version="1.0" encoding="utf-8"?> <calculation:scenario xmlns:calculation="http://www.sap.com/ndb/bimodelcalculation.ecore" schemaversion="2.3" id="adr2" applyprivilegetype="analytic_privilege" checkanalyticprivileges="true" defaultclient="$$client$$" defaultlanguage="$$language$$" visibility="internal" calculationscenariotype="tree_based" datacategory="dimension" enforcesqlexecution="false" executionsemantic="undefined" outputviewtype="projection"> <origin/> <descriptions defaultdescription="adr2"/> <metadata activatedat="2015-04-22 16:13:29.0" changedat="2015-04-22 21:12:59.193"/> <localvariables/> <variablemappings/> <datasour...