C#

Pete O'Hanlon wrote:

you've forgotten to add the XML namespace to the query

XNamespace myNamespace = "some attribute";<br />
var query = from response in xmlDoc.Elements(myNamespace + "PersonsMin")<br />
select response;

Pete O'Hanlon wrote:

Whereever you see xmlns in your XML, that's the namespace that you need to
include to pick it up.

var query = from response in xDoc.Descendants(ns + "PersonsMin")
            select response;

SELECT TOP 1 Count(*) AS Expr1, ScrapCodeID
FROM ScrapCodes 
INNER JOIN Repairs ON ScrapCodes.ID = Repairs.ScrapCodeID
WHERE FailureCode = 13
GROUP BY Repairs.ScrapCodeID
ORDER BY Count(*) DESC;

Ennis Ray Lynch, Jr. wrote:

DateTime.ParseExact("20011215", "yyyyMMdd"); //note the capital M's

DateTime d = DateTime.ParseExact("20011215", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);