Adam, I am looking at the execution plan you just sent that uses a temp table. I'm comparing it to the version you sent at 1:20pm which uses...

Nope. I went and looked at it. It got kicked back here.

Ramesh, I don't believe he has to worry about that. If he first does a crosstab or pivot as Jack suggests, he can just do calculations using...

1. You could expressly create the table with a schema-qualified name ([dbo].[tablename]).

2. Testing IF OBJECT_ID(N'table') IS NOT NULL is a common test for file existence. To...

Jeff, is that new in 2008, or would it work for 2005 as well?

If memory serves, parameter one is PI to 8k decimal places.

You got me, Jeff. Me and table variables were just a summer thing, y'know. That said, any time someone has the ah-hah! moment that execution...

How the @#%&^#! do I go back and find the original posts? It's vital if are to avoid disrupting the space/time continuum. I know...

I loved the touch of Ella, bb.

Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.

"SSC ... it's not a cult. ...

None of the three execution plans attached to your last post use the temp table. All three use the table variable. The first and...

I am sending a rock to St. Lynn, who can cast the first stone at Alvin, before a Threadinator is sent from the near future.

One additional note. If you are dealing with integers instead of date strings, casting/converting integers as varchar will not give the expected ORDER BY results because the...

One of the differences between table variables and temp tables is that no statistics are kept on table variables, while statistics are kept on temp tables. In...

For more fun.....

declare @t1 table (id1 int identity(1,1) primary key, [null] varchar(20))

insert into @t1 values('Null')

insert into @t1 values(null)

insert into @t1 values(default)

declare @t2 table (id2 int identity(11,1) primary key, [null] varchar(20))

insert...

Mum's the word.

Gianluca, I just saw Slash on TV the other night. ...