Hi there. Yup I meant InnerText - just been a long night and day with this, thank you.
I have finally cracked the solution with this. One of those slap palm on forehead moments as I had literally written the answer several times in my code.
I wasn't quoting the correct web uri within my xml namespace definition so my code was somewhat suspect.
I've taken a step back and followed the example as highlighted...
E11esar
Last Activity: Sep 7 '11, 09:06 PM
Joined: Nov 21 '08
Location: UK
-
Yes I have done that but all the suggestions have not worked for me. I thought this would take about an hour to accomplish, so far I have worked on this for over a month now!
It really is getting silly as it can't be this hard to achieve.
Thank you.Leave a comment:
-
Hi there. I am coding in C# but will look up what you have suggested. I am also thinking that maybe Linq to XML might help me, but this is all new to me.
Thank you.Leave a comment:
-
Check InnterText value in XMLDocument
Hi there.
I have written an application which returns an XmlDocument which has several nodes. What I am looking to do is display the InnerText value of one of these specific nodes but I cannot get this to work at all.
I have tried Googling this but none of the results so far have worked, so any help would be most appreciated please?
In my code, I create an XmlDocument and assign it to a returned result... -
Each XML statement is about 10 lines long: probably around 300 charachters in length altogether.
An additional curiosity is I have replaced the series of SELECT 1 debugging statements with select getdate() statements so I can see what time each statement is hit and hence calculate how long specific portions of code take to process, and what I am getting back is getdate() values equal to when I started the stored procedure but these...Leave a comment:
-
"http://madprops.org/blog/Splitting-Text-Into-Words-in-SQL-Revisited/"
I just tried that and it worked.Leave a comment:
-
Take a look at the following, it might help:
http://madprops.org/blog/Splitting-T...SQL-Revisited/
In effect it is just using substring to build / extract the words but ultimately returning a table. You can then use that table to populate your own in the database....Leave a comment:
-
Are you doing this within SQl (as a function or stored procedure) or in a piece of code, such as C#? If in code then you can split each address line into a string array, and use the .replace method to change the likes of St or St. to Street.
Again SQL offers a "replace" method for the same purpose.Leave a comment:
-
Yes I have done that with the stored procedure and it now takes about an hour to hit that first line.
Really is a strange one this.
Have tried Google-ing but so far no luck.
Thank you.Leave a comment:
-
How about using a SQL split function with a space character as the delimeter?Leave a comment:
-
Use of a substring with start and end parameters should cater for what you need, with end parameter being the length of the current string part, e.g 100 would have length 3 and so on.
Remember to start at position 0.Leave a comment:
-
Invoking stored procedure takes a long time to start
Hi there. I have a stored procedure which when invoked using EXEC in Sql Server Management Studio takes about 20 minutes to even start.
The EXEC command includes two input variables which hold XML strings of data, so I'm not sure if this would impact the startup at all?
Once the procedure does start, it finishes quite quickly but I can't see what is causing it to wait for so long to begin processing.
I... -
Temp table
Hi there.
Yes the table is accessible and is created earlier on within the stored procedure.
Thank you.Leave a comment:
-
Stored procedure SQL issue
Hi there.
Within my stored procedure I have a piece of SQL that is supposed to remove from a temporary table, any values that are not set to '1' for a particular field, but this does not work as required.
The SQL in question looks like this:
...Code:DELETE FROM table1 WHERE value_1 NOT IN ( SELECT tab1.value_1 FROM table1 tab1 JOIN table2 tab2 ON tab1.value_1
-
Stored Procedure runs slow at first execution
Hi there.
I have a stored procedure which I need to make more efficient. When first run the stored procedure can take as long as 34 seconds to return results / complete processing, but then any subsequent runs take around 8 seconds; still a bit long as this is for a web service.
Here is how the SP is coded:
...Code:USE [thisTest_DEV] GO /****** Object: StoredProcedure [dbo].[spGetParticipantsByAgreementItem]
-
MySQL
Yes I saw that page but I am doing this in Oracle, so the ideas there didn't work for me.
Thank you.
M :)Leave a comment:
-
String
Thing is I am not using a program to grab this information but SQL that is within a trigger, hence why I am looking for a SQL solution to this one.
After some reading I can see there is a .QUERY function but if I try a command such as
select column_name.Que ry('//OLD') from table_name
then this doesn't work. Can you see what I am doing wrong here please?
Thank you....Leave a comment:
-
String or XML
Hi there.
This would be as a string.
Thank you for your help with this.
M :)Leave a comment:
-
SQL query
I guess what I want is a select statement that will also grab the respective <OLD> and <NEW> value from a column called XML_DATA, so something like
select //OLD from aTable where something = anotherThing though ofcourse using the correct syntax.
M :)Leave a comment:
-
Xpath
Hi there.
I want to take the long xml string and break this down into the individual parts for old and new values, placing each of these into another table that has columns for old and new - hope that makes sense..?
This is for an amendment logging report which will reference the table I want to store these old and new values in, along with other details such as user_id and date, to correspond with...Leave a comment:
No activity results to display
Leave a comment: