Jeff Moden (11/1/2010)

---

Damn! There is a trade off. If you don't know there's going to be dupes or not, pray for dupes when you use it. 🙂

USE...

Paul White NZ (10/29/2010)

---

...in the meantime, here's another simple and obvious use of rCTE's. No timings because I've not yet had the opportunity.[/quote-0]

Table Spool mania! It doesn't perform well;...

Paul White NZ (2/27/2010)

---

...recursive CTEs can be fast, but it is relative. I sometimes use them to seek down the distinct keys of a large index rather than scanning...

Pumpkin.

Was he anything to do with this[/url]?

tosscrosby (10/29/2010)

---

There's a "roach coach" that serves West African food near my place of employment. The goat was fantastic. The beef skin - not so much.....I expected fried...

Not another biltong post? Yes it is.

If you're in the Leamington area, Kate in the Rustic Deli has today received a shipment of kudu biltong. Nom nom nom. Oh yes....

SwePeso (10/29/2010)

---

SELECTSUM(1) AS Items

FROMdbo.tblHhiQuotes

WHERE sGlDate <= '28 Oct 2010'

AND sEffectiveDate BETWEEN '01 Nov 2010' AND '30 Nov 2010'

AND cTransType...

Oops...that's what happens when you don't test. Didn't have SQL Server handy yesterday. Try this:

SELECT COUNT(*)

FROM (

SELECT 1 AS aMatchingRow

...

BenWard (10/29/2010)

---

And the results are in !

My query was the slowest (as was expected lol)

most common speed 156ms with a low of 141 and a high of 196

3rd place...

Andrew I'm gonna 'fess up mate my solution IS...

Alvin Ramard (10/28/2010)

---

I guess a new...

Plumber

It's pretty much guaranteed to be a golden lab's favourite food 😛

CREATE TABLE #Sample (MyStuff VARCHAR(22))

INSERT INTO #Sample (MyStuff)

SELECT '13/01/2010(DD/MM/YYYY)' UNION ALL

SELECT '01/13/2010(MM/DD/YYYY)' UNION ALL

SELECT '14/04/2001(DD/MM/YYYY)' UNION ALL

SELECT '11/03/2002(MM/DD/YYYY)' UNION ALL

SELECT '2010/01/01(YYYY/MM/DD)'

SELECT RIGHT(MyStuff, 12), COUNT(*)

FROM #Sample

GROUP BY RIGHT(MyStuff, 12)