Hm, that's actually a good point. As you were, discuss away...:-)

It's weird: it does the same thing in IE9 (which I very rarely open). Oh well, small irritation, it'll probably go away on...

And yet, in the same browser, using http://extras.sqlservercentral.com/prettifier/prettifier.aspx:

Must be just me then. Perhaps it's a browser cache thing, but I see this:

Is it just me, or is SQL code prettifying (specifically colours) broken on the site at the moment?

GilaMonster (1/8/2012)

---

Yes it did (at least on 7, 8i and 9i), and iirc it was just += or maybe (+)= (its been a while), but my comment was just a...

Jeff Moden (1/8/2012)

---

Let's see... making a toaster-like PC handle something that should be reserved for a much more capable machine and a 5X performance gain to boot?

Mr. White, you've done...

GilaMonster (1/8/2012)

---

The older style for outer joins isn't (+=, =+), but the older form...

That's the problematic old *= and =* outer join syntax. The inner join...

This seems to work reasonably well:

-- Standard in-line numbers table

WITH

N1 AS (SELECT N1.n FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS N1 (n)),

N2 AS (SELECT L.n...

This syntax is the most common in modern code. It brings consistency to inner and...

You're welcome (but removing the extra .query calls is...

Well yes, but I do want to...

Small tweak to Lutz' original code:

WITH XMLNAMESPACES (DEFAULT 'urn:schemas-microsoft-com:xml-analysis:rowset')

INSERT Unit_Test

([End User Name], [Country Code], Units)

SELECT

X.OBI.value('(C0/text())[1]', 'NVARCHAR(100)'),

X.OBI.value('(C1/text())[1]',...

There's a system function shipped as part of msdb that turns an integer date and an integer time into a DATETIME. Being undocumented, using it directly isn't be supported...