Filtrar coluna XML no SQL Server

Para filtrar conteúdos Gerando conteúdo DECLARE @XmlData XML SET @XmlData = N'<TransactionInfo xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema”> <BasketHash>437e04ac543d10433e518a56246ad384</BasketHash> <Billing> <CustormerName>Fabian Corrêa Marques</CustormerName> <Email>test@mailinator.com</Email> <CelPhone>9999999999</CelPhone> <Login>test@mailinator.com</Login> <Identity Type=”CPF”>123456789</Identity> <BirthDate>1986-04-17T00:00:00</BirthDate> <Gender>M</Gender> <AddressLine>Rua Imaginária</AddressLine> <Number>123</Number> <Complement>Apartamento 103</Complement> <Neighbourhood>Centro</Neighbourhood> <City>Porto Alegre</City> <State>RS</State> <Country>BRA</Country> <PostalCode>123456789</PostalCode> <Phone>5555555555</Phone> </Billing> <Shipping> <CustormerName>Fabian Corrêa Marques</CustormerName> <Email>test@mailinator.com</Email> <CelPhone>9999999999</CelPhone> <Login>test@mailinator.com</Login> <Identity Type=”CPF”>123456789</Identity> <BirthDate>1986-04-17T00:00:00</BirthDate> <Gender>M</Gender> <AddressLine>Rua Imaginária</AddressLine> <Number>123</Number> <Complement>Apartamento 103</Complement>… Continuar lendo Filtrar coluna XML no SQL Server