Forum Replies Created
Viewing 15 posts - 1 through 15 (of 30 total)
-
RE: The T-SQL Quiz
Which part of Sergiy's post is true?
-
RE: The T-SQL Quiz
It's funny
-
RE: The T-SQL Quiz
I believe, there is no point in exercizing, if you do not analyze the results
Let's start
Page 1:
Sergiy:
It's funny...
-
RE: The T-SQL Quiz
"P.S. You're cheating about CASE. You told about picking the last value, but you reversed the order because code picks the first one.I don't like cheaters....
-
RE: The T-SQL Quiz
1. I'm giving up
If you still didn't get it you will never get it 
2.
"P.S....
-
RE: The T-SQL Quiz
Sergiy, I'm trying to understand your point.
1. The guy himself is already convinced:
"Im convinced, I would have failed the interview...darn!"
2. Two people provided identical snippets that should explain you sequential...
-
RE: The T-SQL Quiz
No.
'BizzBuzz'
-
RE: The T-SQL Quiz
Agree.
I got even more from the discussion than from the original article.
It means that article is really good.
-
RE: The T-SQL Quiz
1. CASE:
print
case
sign(@i%5) + 2*sign(@i
-
RE: The T-SQL Quiz
Ok. We reach the agreement about Andrew's "concat' logic, yes?
The answer to your question, IMHO, really simple: sequentially. 3 times. It's the same as replace with the last one.
-
RE: The T-SQL Quiz
replace != concat. Period.
-
RE: The T-SQL Quiz
OK
logic
"15 is evenly divisible by 3 so replace with Bizz
15 is evenly divisible by 5 so replace with Buzz
15 is evenly divisible by (3 and...
-
RE: The T-SQL Quiz
Sergiy, I ran 10 Jeff's scripts simultaneously for 100 million rows
As you can see the ratio is close to what I got running single script
WHILE LOOP TEST...
100000000 The final...
-
RE: The T-SQL Quiz
:"By the way, that's quite a laptop you have... what make is it? "
Toshiba Tecra T5, this config is about $3.500
Viewing 15 posts - 1 through 15 (of 30 total)