Stack Overflow
Stack Overflow

Questions tagged [shred]

Shredding refers to the decomposition of XML data structures into the columns of a relational database. It can also refer to overwriting the contents of a file in an attempt to prevent recovery of deleted data.

64 questions
1
vote
0 answers

how to shred XML?

If I have a SQL Server table defined like this: CREATE TABLE MyData ( StepDescription VARCHAR(500), StepDatetime DATETIME, Filedata XML ) In one record, Filedata is: …
Francis
  • 53
  • 3
1
vote
1 answer

Performance issue with SQL Server and XML datatype columns

I am encountering performance issues using an XML datatype column in SQL Server 2016. It looks like my query is looping through the xml over and over. Here is my setup: Create a table with an ID int column (PrimaryKey) and an XML column CREATE…
F43G4N
  • 159
  • 1
  • 1
  • 9
1
vote
1 answer

Shredding XML Data into Tables

I have an issue where I must shred multiple xml datasets from multiple providers into a single set of tables by mapping various elements in the sources to my own tables. I can do this just fine when I am gathering the top level information, but…
Josh
  • 16,286
  • 25
  • 113
  • 158
1
vote
1 answer

Select Data out of XML from a column in ORACLE database

I am trying to select various data out of XML that I have in an oracle Database. Then i can insert those items into another table for normal SQL queries (i.e. shreding the XML). So I have the XML data below in a column that is a Clob column in my…
funkmaster20th
  • 69
  • 1
  • 5
1
vote
1 answer

Shred XML file into SQL Server table

I have researched the best way to shred this xml file extensively and have come close but not all the way to what I want. I am using SQL Server 2012 and have Visual Studio 2012 as well though I prefer to use SQL Server. Here is a snippet of the type…
Jay C
  • 842
  • 6
  • 17
  • 37
1
vote
0 answers

How to shred Column names as well as data from the XML

I have a XML which has a header group with column names and a data group with the actual data belonging to those columns. Sample XML: Column 1 Column 2…
SelectStarFrom
  • 141
  • 1
  • 2
  • 8
1
vote
1 answer

Shredding XML Conditionally in SQL Server

Consider the following XML file: johnsmith@gmail.com Mr John …
TelJanini
  • 835
  • 9
  • 25
0
votes
0 answers

Using output of shred for zenity progress bar

Hello I am new to Linux and wanted to creat a progress bar with zenity using the output of shred. I tried to pipe the output into an echo. But echo doesnt use the input. I also tried piping it into a variable and print it with echo. This also didnt…
BlackRed
  • 1
0
votes
3 answers

Shred XML document in SQL Server

I've started shredding my XML document in SQL Server but I'm stuck on how to get tback out. I can currently only get the 3 elements under inventorymodelday to each row. How do you go "back up" in levels so I can apply the inventorymodel id to each…
owneyjs
  • 73
  • 1
  • 8
0
votes
1 answer

Flattening HTML documents using Jsoup

HTML documents are hierarchical and can be parsed into DOM trees using Jsoup. Is there a way to extract semantic "sections" in those documents, using pattern matching, where each match denotes the start of a "section" and the end of its previous…
PNS
  • 19,295
  • 32
  • 96
  • 143
0
votes
1 answer

Shredding XML in SQL but cross apply adds unwanted records

I have to flatten out this XML source into one SQL server table. There are multiple ResponseID per source file and multiple TextAnalyticsItem per ResponseID. I want to limit the records so that I only get the TextAnalyticsItems related to the…
Fraser
  • 3
  • 2
0
votes
2 answers

SQL Server parse XML column to get a column value if other column value equals certain value

In SQL Server 2014 a table with a CustomColumns column that contains XML data with the following structure: Brand 0 Duprim …
Elen
  • 2,345
  • 3
  • 24
  • 47
0
votes
1 answer

Group data when shredding xml to multiple tables in SQL server

This follows on from this question: Modify XML in SQL server to add a root node In addition to the problem posed and now fixed in that question, I am also splitting the existing table into 2, where the 2nd table is a sub-table of the first, with a…
DannykPowell
  • 1,227
  • 5
  • 18
  • 30
0
votes
1 answer

Parse XML values

I'm new to XML parsing world and i'm need to extract a specific value from a XML field This is my xml structure : CREATE TABLE [dbo].[tempb]( [RECID] [nvarchar](255) NOT NULL, [XMLRECORD] [xml] NULL ) ON [PRIMARY] TEXTIMAGE_ON…
Mar1009
  • 721
  • 1
  • 11
  • 27
0
votes
2 answers

How to query a specific tag from XML field data in sql?

I have an xml field with the name Payload. It has data like this: Nine11 Test now I want to query the RB from Head where it's value is equal to e.g. 'Test. I did this but beyond this I…
scaryghost
  • 77
  • 8
1 2
3
4 5