Viewing 15 posts - 1,876 through 1,890 (of 4,080 total)
Nope. I went and looked at it. It got kicked back here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 9:58 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 9:37 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 8:53 pm
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 8:34 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 8:02 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 7:09 pm
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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 6:32 pm
None of the three execution plans attached to your last post use the temp table. All three use the table variable. The first and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 3:03 pm
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2010 at 2:08 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 5:43 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 5:19 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 3:01 pm
Mum's the word.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 2:40 pm
This remembers me when I attended High school and Slash (Guns and Roses guitarist) died something like once a week...
Gianluca, I just saw Slash on TV the other night. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 7:44 am
Thanks Paul. I really do have to get on the CLR train, don't I? I will get to it right after I rewrite all...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 7:22 am
Viewing 15 posts - 1,876 through 1,890 (of 4,080 total)