OMG that was tense. I was watching NZ with the Italy game picture-in-picture.

How close did Italy come to levelling it 3-3 in the 95th minute!?!?

Still, we finished unbeaten (yay!)...

Gianluca,

With things as they are, both our teams will be going home. We don't look much like scoring.

0-0

Paul

The code in the sys.sp_rename stored procedure contains an explicit check for temporary tables, and raises an error.

It came up in discussion with Paul Randal.

There is a technical paper on it:

http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.92.2044

Click on...

SELECT CT.Contact_ID

FROM ContactTracking CT

WHERE CT.contact_date > '20090110'

AND CT.Call_end_time IS NOT NULL

AND Contact_ID IN ('122734', '122738')

AND ...

*sound of bubble bursting *

🙁

Random fact for the day:

On a table clustered on an integer IDENTITY column, SQL Server Enterprise can use linear interpolation to find the row data on the page from a...

Absolutely.

SET NOCOUNT ON;

GO

CREATE TABLE dbo.Example

(

...

Which happens to be my birthday!

I guess it's because there's no-one else to do...

Yep there's lots of variations:

SELECT 'One row', SUM(CASE WHEN 1 = 0 THEN 0 ELSE...

Scary isn't it!

I blame a fellow MVP of yours: Rob Farley for all this - he reminded me of it in...

It still gives me nightmares from time to time :blink:

I used to think I understood the basics of SQL.

Rick Lang (6/21/2010)

---

Perhaps a different version of the question where the answer would be different with the Having clause vs just the where clause might help to clear up any...