Search results for query: *

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>...

What are your results from this query? EXEC msdb.dbo.sysmail_help_account_sp; Dave [idea] [http://flashspot.com]

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]

Thank you so much, Olaf! I'll give this a shot. 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...

Would COALESCE apply? Dave [idea] [http://flashspot.com]

Is it as simple as a replace? Something like (REPLACE(CALL.TEXT04,CHAR(13),' ')) to replace a CR with a space? Dave [idea] [http://flashspot.com]

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...

Have you tried creating a DB that only contains links to the specific tables? Dave [idea] [http://flashspot.com]

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]

Another option, depending on your SQL Server version: SELECT (FORMAT(GETDATE(),'MMddyyy')) 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]

I found this nearly fifteen (!) year old article. http://www.4guysfromrolla.com/webtech/111500-1.shtml Dave [idea] [http://flashspot.com]