No announcements
Found 2237924 threads
-
1 VotesNew Query - From Folder, XML fails as multiple roots
Hi I am trying to use the from folder feature in power query in 2016. The goal is to be able to add multiple XML ...Answered | 3 Replies | 2831 Views | Created by SaythJ - Wednesday, October 21, 2015 5:53 AM | Last reply by Ehren - MSFT - Thursday, October 22, 2015 5:47 PM
-
2 Votes
multiple xml files in folder from power query
I'm trying to read in multiple xml files from a folder. The combine function works and if I view the text output from the combined rows then you ...Answered | 4 Replies | 7743 Views | Created by Tim Windsor - Friday, June 13, 2014 3:41 PM | Last reply by Imke Feldmann - Wednesday, July 15, 2015 1:33 PM -
0 Votes
query output as XML
no, not directly from SQL Mobile. you can fill a DataSet with your query results using the adapter or data reader and then convert the DataSet into XML....-DarrenAnswered | 1 Replies | 9499 Views | Created by Bruce Baker - Tuesday, December 13, 2005 6:22 AM | Last reply by Darren Shaffer - Wednesday, December 14, 2005 3:39 PM -
1 Votes
XML Large File Disassembling with multiple Roots nodes in XSD
root? From the looks of the schema the XML will always have Enveloppe as the root, in which case you should change the root reference to Enveloppe and remove the body xpath ...Answered | 6 Replies | 9128 Views | Created by Alix_v1 - Wednesday, May 6, 2009 2:07 PM | Last reply by eliasen - Thursday, May 7, 2009 8:44 PM -
0 Votes
Loop through all xml roots
Hello ALL: I need to use powershell to loop through all root nodes, and in each root search for ...Answered | 1 Replies | 6668 Views | Created by VuaCorona - Monday, August 30, 2010 4:27 PM | Last reply by Boe Prox - Monday, August 30, 2010 4:52 PM -
0 Votes
Multiple XML Files as DataSource
Hi All, New to the forums, so, hello. I want to import data from multiple XML files into SQL 2005 using SSIS. I know how ...Answered | 4 Replies | 7804 Views | Created by Drammy - Thursday, May 10, 2007 8:27 AM | Last reply by Rafael Salas - Monday, May 14, 2007 1:00 PM -
1 Votes
Using XML as a query
an article about using XML as data source step by step, please see: httpAnswered | 3 Replies | 2692 Views | Created by TheTurdFerguson - Thursday, May 10, 2012 12:49 PM | Last reply by Robert Eckman - Friday, May 11, 2012 4:52 PM -
0 Votes
# of DFS Consolidation Roots?
DFS consolidation roots are always standalone namespaces, not domain namespaces. You can have multiple consolidation roots per computer and you can have multiple ...Answered | 1 Replies | 3110 Views | Created by ASutherland - Thursday, December 1, 2011 10:10 PM | Last reply by JoseBarreto - Friday, December 2, 2011 1:07 AM -
1 Votes
T-SQL query as XML
Hi, i would like to query data from a table and save it as an xml file. The xml should have the following ...Answered | 5 Replies | 7894 Views | Created by Kirizzle - Wednesday, February 2, 2011 12:45 PM | Last reply by Naomi N - Tuesday, February 8, 2011 2:14 AM -
0 Votes
Query XML with multiple elements
DECLARE @MFRXML XMLAnswered | 12 Replies | 10210 Views | Created by jchaney88 - Wednesday, December 24, 2008 3:21 PM | Last reply by jchaney88 - Wednesday, January 7, 2009 9:45 PM -
0 Votes
Query From XML
]', 'nvarchar(50)') , T.Item.value('(NIN)[1]', 'nvarchar(50)'), T.Item.value('(Enforce)[1]', 'bit') FROM @XmlData.nodes('employees/employee') AS ...Answered | 1 Replies | 944 Views | Created by himo - Tuesday, April 3, 2018 5:18 AM | Last reply by Visakh16 - Tuesday, April 3, 2018 5:27 AM -
1 Votes
New-WebServiceProxy results as XML
also, you should try running this all in a console first before making it a script, not as easy to see whats going on if you do it right from script. this is by far one of the bestAnswered | 6 Replies | 7205 Views | Created by steve verschaeve - Wednesday, August 11, 2010 9:28 AM | Last reply by steve verschaeve - Thursday, August 12, 2010 7:06 AM -
0 Votes
Query Xml without Namespace prefix fails ???
I am having a problem querying Xml data in SQL SERVER 2005 if there is an xmlnamespace that does not have a prefix. The query ends up returning a NULL field. The minute I ...Proposed | 2 Replies | 9432 Views | Created by Jimmy Q - Wednesday, June 17, 2009 2:46 AM | Last reply by RBarryYoung - Wednesday, June 17, 2009 11:42 PM -
0 Votes
setting body xpath to multiple roots in envelop
hi John, Can you please help me how to set multiple roots as a body xpath. Regards, Amit MoreAnswered | 3 Replies | 678 Views | Created by Amit C More - Friday, May 8, 2015 1:01 PM | Last reply by Johns-305 - Friday, May 8, 2015 6:36 PM -
0 Votes
Event Log XML Query folder path
' and Data='D:\folder\folder\folder']]] </Select> </Query> </QueryList> \_(ツ)_/Unanswered | 2 Replies | 435 Views | Created by BobinLolico - Thursday, April 4, 2019 10:39 AM | Last reply by BobinLolico - Thursday, April 4, 2019 11:39 AM -
0 Votes
From Folder, Multiple Files
There are numerous samples in the web for importing from folder that will tell you that you have to create a sample query that works on one file and transform that to a ...Answered | 1 Replies | 296 Views | Created by JuddH99 - Saturday, February 9, 2019 8:45 PM | Last reply by Imke Feldmann - Sunday, February 10, 2019 7:19 PM -
1 Votes
How to return sql query as xml
R.RaceNumber, R.RaceName, R.Distance, R.Conditions, R.TrackType, R.StartTime FROM Races AS ...Unanswered | 1 Replies | 1672 Views | Created by CuriousCoder15 - Monday, January 21, 2019 11:45 AM | Last reply by Visakh16 - Monday, January 21, 2019 12:08 PM -
0 Votes
XML OPENROWSET query fails with xmlns: entry in XML header
Hello, everyone. I am new to dealing with XML data in SQL Server. I am developing a procedure to import billing data from a standards auditing ...Answered | 5 Replies | 10539 Views | Created by Ivo Manuel Mendes Pereira - Monday, December 21, 2009 12:36 PM | Last reply by wBob - Tuesday, December 22, 2009 3:28 PM -
0 Votes
Query on XML node with multiple namespaces
('mdd:CellData/mdd:Cell') c(c) You can query the xml from a variable - there is no need to put it into a table variable as well unless you need to for some ...Answered | 4 Replies | 6126 Views | Created by J. Shiangoli - Tuesday, March 19, 2013 7:35 PM | Last reply by wBob - Tuesday, March 19, 2013 10:23 PM -
0 Votes
Correct XML query from table
MSDN - Import XML into Table - Pls mark as answer/vote, if this post is helpful Sugumar ...Answered | 8 Replies | 1703 Views | Created by -VB- - Monday, October 7, 2013 7:04 AM | Last reply by -VB- - Monday, October 7, 2013 5:43 PM - Items 1 to 20 of 2237924 Next ›
No announcements
