Viewing 15 posts - 1,501 through 1,515 (of 4,080 total)
I agree with Lutz.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 14, 2010 at 4:11 pm
Okay... someone alleviate my ignorance and tell me what "dfft" means.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 14, 2010 at 12:17 pm
You were too quick for me, Seth.
Paul, whenever you do something in SQL, it is almost always preferable to NOT use a loop. That is procedural thinking that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 14, 2010 at 10:11 am
declare @item_sk int
set @item_sk = 4220
select @item_sk as item_sk, CASE when exists (select 1 from #group_items where item_sk = @item_sk and description = 'filed')
then 'Yes'
else 'No'
end as filed
You could modify...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 14, 2010 at 9:54 am
The Dixie Flatline (7/7/2010)
From Books Online (the section on RAISERROR):
When RAISERROR is run with a severity of 11 or higher in a TRY block, it transfers control to the associated...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 14, 2010 at 9:00 am
I don't think anybody misunderstands anything after all this time. Yes, the flow of the procedure is interrupted when evoked from within a try/catch. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 13, 2010 at 9:54 am
rajmaiet,
Please submit your question as a new question, rather than tacking it onto someone else's question.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 13, 2010 at 9:29 am
Congrats, Jeff. I will bring a big bag of peanuts to your session so your SSC fans can throw them at you if you mention Hamster Poo.
I'm off...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 5:16 pm
It has UNIONs and inside out subqueries and finally a pivot table construct (not that any of those are bad, they just don't lend themselves to readablity).
Agreed,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 4:23 pm
Double Forward Fourier Transforms ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 3:52 pm
Jeff, you have hp on the brain.
You need to clean the cages out more often ,,, or naybe less often. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 3:32 pm
Good that you included gals. Very bad to give offense.
At least one practices with edged weapons... and fiber-optic laser disassemblers. She showed remarkable...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 3:21 pm
I can't help. I ran your code and got the same puzzling results. Then I looked through books online and it reads as if the results...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 3:15 pm
If you look closely at the execution plan for your first example, you should see that it only pulls the column(s) necessary for filtering or output from the joined table....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 3:10 pm
Are you pondering what I'm pondering, Alvin?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2010 at 9:37 am
Viewing 15 posts - 1,501 through 1,515 (of 4,080 total)