There is an XML with the structure: – Item – Documents – Document – Records – Record – Category – Code – Value And here is the SQL query that …
Tag: xml
Delete xml node with a specific CDATA
This is part of my XML: I need to delete the EO node with <![CDATA[0001FFFFFFFF]]>,across the table using Oracle. This xml is stored in XM_DATA_CACHE of XMLTYPE. Is there a way to delete based on CDATA Final output should be Answer First of all your xml is broken: second tag GoalMeasurementEORow is not …
SQL Server XML Parsing Null Result
Hello I have procedure like below USE [DB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[AdminTestSaveAnswer] @refQuestion xml AS BEGIN SET NOCOUNT ON; SELECT …
Using a Scalar Function that expects a Table Parameter inside an Apply block
TLDR: I have a scalar function, that expects a table-valued parameter and returns the XML representation of that table. Now I need to use this function in a larger Update statement, where the table-parameter of the function is generated by inner Select statements. Hi, We have an XML type definition, say [dbo]…
Without loop how to insert values into table from XML node
I have the following requirement. I have an XML variable of values. I now should insert the values for this XML variable to a table (Table A), but need to check if the items (one by one) in the XML variable are already present in another table (Table B) and the count of that individual item present in table B
SQL Server – Ordering Combined Number Strings Prior To Column Insert
I have 2 string columns (thousands of rows) with ordered numbers in each string (there can be zero to ten numbers in each string). Example: The end result is to combine these 2 columns, sort the numbers in ascending order and then put each number into individual columns (smallest, 2nd smallest etc). e.g. Cols…
How do I extract a value from an XML column in SQL Server
I have a column SCORERESULTS in table CSE_ARCHIVEDCREDITSCORE. Score results is an XML column. <Profile id="Navigation" version="1" num="4" …
How to insert the xml nodes with same name and ignore based on the attribute
I have a below xml ` ` I need to insert only the dob nodes which has D and M and Y attributes in table (Table A), if only Y attribute is specified then the entire tag need to be inserted in another table (Table B), how to achieve this is SQL. Thanks for your suggestions Answer Are you looking
insert XML request into clob column using Oracle
I do have XML request as below: I wanted to insert it into a table in clob column but due to double quotes (” “) it is not insertable and below error is observed . SQL Error: ORA-01756: quoted string not properly terminated it is not insertable. Please suggest Answer Oracle uses single quotes to d…
Best way to import XML into a database C# .NET Core
I’m working on a project that requires that I take data from an XML API that I don’t control and insert that data into a database (I control) for consumption by a different application (I control but …