Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Who dare to beat me?

Author  Topic 

RatTail
Crackhead

98 Posts

Posted - 2003-04-11 : 16:22:50
http://sql.ipps.ru/

(see bottom of the page)

======
Hoo!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-11 : 16:33:43
[url]http://sql.ipps.ru/?Lang=1[/url] Ahhh, must better.

Tara
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-04-11 : 16:37:38
I did like 5 of them but it is really boring ... i assume it gets harder? kind of a cool idea, though, I guess.

- Jeff
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-11 : 16:49:08
quote:

I did like 5 of them but it is really boring ... i assume it gets harder? kind of a cool idea, though, I guess.



5 of them! I did one of them and got bored.

RatTail,

I'm surprised that you did so many of them. Weren't they a little too easy?

Tara
Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-11 : 17:37:21
Gens!

Believe me, it's a very interesting sql adventure!
And it will be more and more harder! :-(
At the time VVG_ takes the 1-st place and this man is a
very cool sysadmin from Saint-Peterburg. Be this thing baby rubbish
he... (you see what I mean). In short, it's not for beginners.

Anyway, imagine: in a month the first place is occupied by famous nr!

RT




Edited by - rattail on 04/12/2003 21:50:43
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-12 : 06:37:20
I did the first few and they have an incorrect answer already.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-12 : 07:16:28
2nr
>and they have an incorrect answer already.

Impossible. Maybe mistranslation (hardly so)? Contact them msi77@mail.ru
Pity if you quit... You succeed pretty fast (R N. ???)

>an incorrect answer
That's why not all managed to go thru 62 exercises (1-st stage).

Or maybe you used a very specific T-SQL expression? There are some
restrictions at this point.

=====
RT


Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-12 : 07:19:58
They said in the question
all laptops with price less than any pc (i.e. less than the max pc price)
where they meant
all laptops with price less than all pc's (i.e. less than the min pc price)


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-12 : 08:03:50
I've just reported them this howling mistranslation.

=====
RT


Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-12 : 08:21:45
It was 17 2
Find the laptops having speeds below those of any PC. Result set: type, model, speed.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-12 : 08:40:58
It does not matter. I think they've learned their exercises by heart
and will check all of them.

======
RT


Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-12 : 18:55:16
Just received the reply:

If you mean #17 (with speeds, but not prices), the question will be
corrected as soon as possible.
Thank you for your message.
You can take part in solving the second phase exercises (after #62).



Go to Top of Page

RatTail
Crackhead

98 Posts

Posted - 2003-04-13 : 12:16:47
... Like a regular bulldozer...


Go to Top of Page

Serge I
Starting Member

10 Posts

Posted - 2003-04-14 : 03:02:00
From dev
All errors you maybe have collided with are due to mistranslation from Russian. Not so good English prevent us from guarantee to give fully correct formulations of questions.
Please, contact me msi77@mail.ru if you find the translation errors or misunderstood questions.
More hard questions wait you after #62.
I'll be able to reply up to 2003-04-15 and after 2003-04-19.
S.I.


Go to Top of Page
   

- Advertisement -