Return only 1st value for all row while retrieving element text value from xml using open xml file. WHERE NOT EXISTS (select gtin from MasterData) ĮXEC sp_xml_removedocument Septem5:05:16 AM - prasad RequestedQuantity int './requestedQuantity'
RequestedDeliveryDate datetime '././orderLogisticalDateGroup/orderDeliveryInformation/requestedDeliveryDate',ĬancelDate datetime '././orderLogisticalDateGroup/OrderCancelInformation/CancelDate', Name (60) '././shipTo/nameAndAddress/name', UniqueCreatorIdentification varchar(20) '././orderIdentification/uniqueCreatorIdentification', PurchaseOrganization varchar(5) '././orderIdentification/purchaseOrganization', SELECT entityType,purchaseOrganization,uniqueCreatorIdentification,gln,name,requestedDeliveryDate,CancelDate,gtin,requestedQuantityįROM 'Orders/lineItem/tradeItemIdentification')ĮntityType varchar(5) '././orderIdentification/entityType', Print and Execute SQL Insert Statement to load fileĮXEC sp_xml_preparedocument OUTPUT, INTO MasterData SET INTO dbo.XMLFilesTable(FileName, LoadedDateTime,XMLData)įROM Openrowset( Bulk Single_Blob) as Image' INSERT INTO #FileList (FileName,Depth,FileFlag) Load the file names from a folder to a table IF OBJECT_ID('tempdb.#FileList') IS NOT NULL
I have a similar problem, I have several XML files in a folder, but when reading these, I only read the last file I have, be it 2, 5 or more. can you pleas advise why?ĭECLARE AS XML, AS INT, NVARCHAR (MAX) Pleas can you help me, I am trying to extract the data from the xml like in your example but i only get the StoreCode. EXEC sp_xml_preparedocument OUTPUT, StoreCode, itemqtyĮXEC sp_xml_removedocument Febru10:37:49 AM - tal
0 kommentar(er)
