Viewing 15 posts - 1,681 through 1,695 (of 4,080 total)
(whew) It took me 45 minutes to catch up.... I'm out of breath from reading so fast.
1. How hard can it be to spell GliaMonster correctly?
2. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 8:05 pm
It depends
Steve!! Sue him for copyright violation!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 31, 2010 at 7:55 pm
Barry and Grant: I'd love to hear (privately) the comments that might get you in trouble. My imagination is failing me.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2010 at 6:36 am
To make this work, you are either going to have to pass your list of rows as a table-valued parameter OR use the CHARINDEX or PATINDEX function to see if...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2010 at 6:24 am
A set of rows is NOT a string. It's a table-valued parameter. You seem to be confusing a passed parameter with building a string dynamically....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2010 at 6:17 am
declare @Company_Name_Code varchar (4)
declare @test-2 table (company_name_code char(1))
insert into @test-2
select '1' union all
select '2' union all
select '3'
set @Company_Name_Code = '2' -- will work
-- set @Company_Name_Code = '1,2' -- will return...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2010 at 5:57 am
Comment withdrawn. My guess would be that you are trying to use the same parameter as both a scalar and a table variable at the same time. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 30, 2010 at 5:45 am
It's not so bad, Lutz.
ROW_NUMBER() + Tally table + CASE expression = powerful dynamic SQL. 😀
-- variable number of followup dates demands dynamic SQL
declare @sql...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 29, 2010 at 9:01 pm
Maybe it's because your face is marred by dust and sweat and blood....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 29, 2010 at 7:53 pm
Finally got caught up, both here and in the "Missing" thread. I tried to tell y'all last week to just ignore the interruptions and go on with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 29, 2010 at 5:59 pm
Again from BOL:
If the table is a heap, which means it does not have a clustered index, the row locator is a pointer to the row. The pointer is built...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 29, 2010 at 3:02 pm
Once again, it depends! 😛
From BOL on Nonclustered Index Structures:
If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 28, 2010 at 5:25 pm
Loved Kelly's Heroes. I still remember Oddball walking up to the German tank and unfastening his holster to be ready for a quick draw.
With respect to dealing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 26, 2010 at 1:43 pm
Peer review. For the MCJ, would this need to be a video, or could a project, including code, that could be tested in a lab environment by independent individuals be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 26, 2010 at 1:39 pm
HERESY!
The Thread controls all.
Great is The Thread.
Mighty, mighty is the Thread
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 26, 2010 at 12:01 pm
Viewing 15 posts - 1,681 through 1,695 (of 4,080 total)