Group: microsoft.public.sqlserver.xml · Group Profile · Search for Storename in microsoft.public.sqlserver.xml
Author: Martin Honnen
Date: Jun 6, 2007 04:52
...AquirerBank[1]', 'VARCHAR(5)') AS AquirerBank ,x.item.value('@AcquirerID[1]', 'int') AS AcquirerID ,x.item.value('@StoreName[1]', 'VARCHAR(50)') AS StoreName ,x.item.value('@MerchantID[1]', 'VARCHAR(50)') AS MerchantID FROM @Merch.nodes(' declare default element namespace "http://www.mywebsite.com/supMerchants"; ...
| 
