No announcements
-
0 VotesWelcome message and some guidelines
Welcome dear seeker of XML knowledgePlease take some time to read this welcome message that can help you find your answer quicker.Please take a look at previous postings to see whether your question ...Sticky | 3 Replies | 54020 Views | Created by MRys - Friday, November 4, 2005 8:20 PM | Last reply by mafsar09 - Tuesday, February 12, 2013 3:53 PM
Found 3738 threads
-
0 Votes
If thers is Same ids then one row should be appeared instead of 2rows
Hi All, I am writting below pvote table query . I got result below table,in this i want modification in requirement. If there is same Emp_id, Rs_Id and ...Unanswered | 3 Replies | 1711 Views | Created by Priyanka1592 - Monday, August 10, 2020 4:52 AM | Last reply by Erland Sommarskog - Monday, August 10, 2020 9:46 PM -
1 Votes
VB.Net read xmlfile and create array from data
I have an xml file that I would like to read and if one of the values is true I would like to take information and build an array. Here is a snipet of my xml ...Answered | 7 Replies | 1665 Views | Created by JRDumont - Friday, August 7, 2020 12:17 AM | Last reply by Yitzhak Khabinsky - Friday, August 7, 2020 3:31 PM -
0 Votes
The FOR XML CLAUSE in SQL Server 2019 is not respecting WITH XMLNAMESPACES
The SQL below is producing different results in SQL Server 2017 and SQL Server 2019 with SQL Server 2019 not returning the expected XML namespace. SQL Server 2017 was tested using Standard edition on ...Answered | 4 Replies | 1504 Views | Created by paul.g.miller - Thursday, August 6, 2020 3:39 PM | Last reply by Yitzhak Khabinsky - Thursday, August 6, 2020 4:42 PM -
0 Votes
Handle millions of XML files in SQL Server
Hello everyone, I want to know what is the best way to handle millions of XML files smaller than 50 kb Is there a comparative table on ...Unanswered | 7 Replies | 1779 Views | Created by SebaSQL - Tuesday, August 4, 2020 4:31 PM | Last reply by jchang61 - Tuesday, August 4, 2020 10:23 PM -
0 Votes
xQuery - Element Name Error
...Proposed | 6 Replies | 1997 Views | Created by Hash New - Saturday, August 1, 2020 11:41 PM | Last reply by Yitzhak Khabinsky - Tuesday, August 4, 2020 5:55 PM -
0 Votes
Need assistance on SQL FOR XML PATH
Hi I would really appreciate some assistance. I'm using the SQL FOR XML PATH but I have some issues with the ...Proposed | 2 Replies | 1495 Views | Created by FredrikUmea - Tuesday, August 4, 2020 10:07 AM | Last reply by Online Computer Docs - Tuesday, August 4, 2020 10:33 AM -
0 Votes
complex node xml output file using sql data table.
Hi All, Now I am correct forum. i am trying to build xml file with following tables and data.. I have already got middle part ...Answered | 11 Replies | 2044 Views | Created by papillon28 - Thursday, July 30, 2020 2:34 PM | Last reply by papillon28 - Friday, July 31, 2020 6:18 PM -
1 Votes
insert attribute question
update XmlTest set data.modify('insert attribute {sql:column("xd.id")} into (/additionalcols)[1]') from [xmldata] xd where xd.id = ...Answered | 6 Replies | 11303 Views | Created by Darsan - Monday, October 30, 2006 9:38 PM | Last reply by Yitzhak Khabinsky - Monday, July 27, 2020 11:16 PM -
0 Votes
sql query for nested elements with extra elements - Need help
I need output like below how to approach plz help me out? T.I.A 1 customer has multiple locations and 1 location has multiple phone numbersAnswered | 11 Replies | 2330 Views | Created by papillon28 - Wednesday, July 22, 2020 5:42 AM | Last reply by Stefan Hoffmann - Thursday, July 23, 2020 3:06 PM -
1 Votes
How to grouping elements and sum values in XSLT 1.0
Hi TEam, Currently i have write a XSLT map for a multiple parent charge Codes groups and sum their values on same group , buts its not working so Could you please support to get a ...Answered | 3 Replies | 2552 Views | Created by Maheshma - Monday, July 20, 2020 6:15 PM | Last reply by Maheshma - Tuesday, July 21, 2020 5:06 PM -
0 Votes
How Can i get a Current Date on XSLT 1.0
Hi Team, Currently we have a requirement to get a current date time to my Xslt 1 map, According to i have used below namespace expression and to get a current dateTime to XML ...Answered | 2 Replies | 2438 Views | Created by Maheshma - Friday, July 17, 2020 3:00 PM | Last reply by Maheshma - Sunday, July 19, 2020 5:00 PM -
1 Votes
Get the Xml Node values into a table
Hello, I have a table with columns Nodeid and XmlData. In XmlData the data is looking as below '<fNews id="12211" ...Answered | 1 Replies | 2128 Views | Created by aravind T - Saturday, July 11, 2020 10:56 PM | Last reply by aravind T - Sunday, July 12, 2020 1:26 AM -
2 Votes
sqlxml bulk load - schema relationship expected ...
Hi ... I am trying once again to load data from an xml file into a sql table using sqlxml com. I have started small only trying to insert one column into the table. I ...Answered | 5 Replies | 17903 Views | Created by Chris55 - Wednesday, April 2, 2008 4:33 PM | Last reply by Jackie_K - Monday, June 22, 2020 3:03 PM -
2 Votes
XML Parent and Child nodes into tables
Hi, I want to move Parent attributes to one table and child attributes to another table and there should be relationship between two tables. Is is possible to generate Id for parent ...Answered | 3 Replies | 6599 Views | Created by Vinuthna - Tuesday, August 12, 2014 9:03 AM | Last reply by Sudip_inn - Friday, June 19, 2020 4:53 PM -
0 Votes
How to get PackageName of a called package from a SSIS project package with XMLNAMESPACES?
Hello, I am trying to document an SSIS project which calls-off a few other packages. I am able to get some details out of the packages called from the project package ( ...Unanswered | 2 Replies | 3038 Views | Created by NL_Jaap - Thursday, May 14, 2020 1:09 PM | Last reply by Yitzhak Khabinsky - Friday, June 19, 2020 1:42 AM -
0 Votes
TSQL Except statement to compare output of several different views which have different collation sequence
I'd like to compare the output of two different views to ensure data has been migrated successfully. The following would work great: select * from ...Answered | 2 Replies | 2769 Views | Created by vsdla - Monday, June 8, 2020 11:02 PM | Last reply by vsdla - Tuesday, June 9, 2020 9:56 PM -
0 Votes
Get Data from CRMOnline using TSQL
Hello, The following statement retrieves data from the Account Entity in CRM. We are utilizing SSIS to get this data and then insert it into a SQL Server table so it can be ...Answered | 9 Replies | 2880 Views | Created by vsdla - Tuesday, May 26, 2020 8:12 PM | Last reply by vsdla - Wednesday, May 27, 2020 7:31 PM -
1 Votes
Implementing parent-child approach in FLWOR structure
Hi, my desired outcome is work with a parent-child rows struct but I don't know how to implement it using FLWOR approach here you have an example of my ...Answered | 2 Replies | 3110 Views | Created by Enric Vives - Wednesday, April 15, 2020 10:22 AM | Last reply by Enric Vives - Friday, April 17, 2020 7:40 AM -
1 Votes
Trying to post a XML section just once
Hi there, I would need to define one section just once in my XML generation by using Xquery/FLWOR approach. Example of data -the ...Answered | 1 Replies | 2870 Views | Created by Enric Vives - Wednesday, April 1, 2020 10:07 AM | Last reply by Yitzhak Khabinsky - Wednesday, April 1, 2020 12:37 PM -
0 Votes
extract data from xml child nodes and its child nodes data from XML column
Hi, I have SQL 2016. I have one table with datatype XML.I want to extract the data from XML Nodes and its child nodes data values. My XML Data format ...Unanswered | 11 Replies | 3806 Views | Created by Dileep sankar - Monday, March 9, 2020 6:48 PM | Last reply by Yitzhak Khabinsky - Tuesday, March 31, 2020 12:41 PM - Items 1 to 20 of 3738 Next ›
No announcements
