Recent content by ElEye

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]