I'm stymied how to parse some XML.
Specifically, I seek to parse the following XML:
DECLARE @XMLText xml = '<result>
<record>
<field name="usid" id="usid" value="9876" />
<field name="namel" id="namel" value="Jon" />
<field name="namef" id="namef" value="Anderson" />
</record>...
I thank you very much for your reply!
I tried this on the full XML and the response is 'Only one top level element is allowed in an XML document.' I Googled that and I did not find anything that clued me in to resolve it. Your script does work on my short XML sample, but does not on the actual...
I have the following query the runs very slowly. The sample below is just a few XML records. The actual data contains ~11,000 records and takes ~13 minutes to execute. Surely, I'm doing something wrong here. I seek guidance on how to speed up my query. TIA!
DECLARE @xml XML
SELECT @xml =...
I think you're looking for MAX from VALUES.
http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx
Dave [idea]
[http://flashspot.com]
By the way, after you straighten out the path issue, best practice is to have your primary and log files on different drives from each other.
Dave [idea]
[http://flashspot.com]
This may be simple, but so is my brain. So I seek assistance with the following.
I need to compare a field in each of two tables to create an "is equal" where not equal. For example, "USA" in table one would be considered equal to "United States" in table two, "CAN" in table one would be...
I've seen your post move from forum to forum. Kinda tough when this does apply to several technologies.
Without knowing anything about your code, first thing I'd check is the PHP version. In IIS for each site you can set the PHP version. Another thing to check is the PHP extensions, which are...
Side note: While you're in there, if you can I suggest you abandon OLE DB in favor of SQL Server Native Client. Microsoft announced in 2011 that OLE DB will be end of life soon. (Whatever soon means since it's five years later now.)
Dave [idea]
[http://flashspot.com]
Since words can vary in length I would think a good approach would be div tag of a certain width rather than ASP that adds a line break. Or is there more to this?
Dave [idea]
[http://flashspot.com]
As Chris wisely stated, your hosting provider may have changed something. If so, the first place I'd look is ASP properties in IIS. If you don't have access to that you can try a very small file and if successful then it could be related to the filesize, that possibly being an IIS parameter...
What, "Unspecified error" is not clear enough for you?
Stab in the dark: check the email server presence and username/password for any changes/issues.
Dave [idea]
[http://flashspot.com]
Do you have access to a SQL Server? If you have a newer version you can use functions like GETUTCDATE, SYSUTCDATETIME, SYSDATETIMEOFFSET to do the work for you. Use a DB query in ASP to get your "isBST" binary result.
BTW: Kudos to you for saying "Daylight Saving Time" and not "Savings Time."...
Have you tried CTE (Common Table Expression?) If that's not clear you may want to post your inquiry to the SQL Server Programming forum. Here's a link I found: https://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/
Dave [idea]
[http://flashspot.com]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.