Forum Replies Created
Viewing 15 posts - 3,031 through 3,045 (of 4,080 total)
-
RE: Setting default input variable for stored proc
No problem, Jace 🙂
Several times, I've realized that I missed something significant in the original post. Surely it happens to other people too.
--------------
LD, you are quite welcome.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query unique main key with greatest secondary key
I'm really glad to hear that are you concerned about efficiency. Here are the tried and true ways to measure performance.
declare @timer datetime
Set statistics time on; ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Note to self: Only drink water... in small sips... while reading 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 -
RE: Are the posted questions getting worse?
Yes, John, you were.... and you were.
(applause, thunderous applause)
But now we're at 3501 and moving on towards 4,000... the moment was just too good to last.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Just Walk Away - Blacklisting - and Twits without Twitter
VARCHAR(MAX) is tough on Tally table and other pseudo-cursor solutions for a number of reasons.
So the answer is "It depends." No doubt you will be honest...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Setting default input variable for stored proc
You could also do this:
1. Use @TermPeriodId int = NULL in your parameters list.
2. Immediately following SET NOCOUNT ON;
set @TermPeriodId = isnull((select termperiodid from...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: CASE, EXISTS and GROUP BY in the Same Statement
Yes, new in 2005, CTEs are (for me) much easier to follow alternative to subqueries. They are like views that only exist for a single query. I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: CASE, EXISTS and GROUP BY in the Same Statement
I'm part of the 1% of SQL humanity that hasn't read your article yet. Is it on your blog?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: CASE, EXISTS and GROUP BY in the Same Statement
Barry!! You're AWAKE !!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
One Thread to rule them all.
One Thread to find them.
One Thread to bring them all
and in the darkness bind them....
Glad you could join us, Flo.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: How To Format Phone Number
You didn't learn to program in RPG did you? 😀
I've used both SUBSTRING and STUFF. Lately I've stayed with STUFF. You should also test...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: CASE, EXISTS and GROUP BY in the Same Statement
While we're all scratching our heads, may I suggest that you simplify this a little by using a CTE up front to develop values? Use your existence test...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
You got extra points if it was a nasal coke spew.
You should get extra points... those suckers are painful !!
Pork chops... I don't even want to think about it. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Searching for case sensitive data
I'm not one to throw stones... especially where the word "fool" is involved 😉
By the way, the respect is returned.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
I have nothing to offer but blood, toil, tears and 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
Viewing 15 posts - 3,031 through 3,045 (of 4,080 total)