Author |
Topic |
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-26 : 10:08:04
|
Evidence found here for arrival last week of November! Peter LarssonBjuv, Sweden |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 10:13:30
|
CONGRATULATION PETER ! KH |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 10:15:12
|
Guess you should be busy with your new DBA rather than saving lost  KH |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-26 : 10:24:06
|
I didn't understand what the picture is about?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 10:26:45
|
quote: Originally posted by harsh_athalye I didn't understand what the picture is about?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Guess you are still single [HINT] : it's the result (not the query result) KH |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-26 : 10:28:56
|
Picture is little shaky, as I were when taking the photo Peter LarssonHelsingborg, Sweden |
 |
|
X002548
Not Just a Number
15586 Posts |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 10:30:02
|
quote: Originally posted by Peso Picture is little shaky, as I were when taking the photo Peter LarssonHelsingborg, Sweden
You must be too excited. Is this Primary DBA ? KH |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-26 : 10:34:03
|
Yes! In this joint venture.No. Have a junior DBA with 3 year experience with former (disaster) alliance.Peter LarssonHelsingborg, Sweden |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-26 : 10:40:12
|
I think I got you.Are you becoming a proud father of a baby?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-26 : 10:49:52
|
Very much so!Peter LarssonHelsingborg, Sweden |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-26 : 11:21:43
|
Congrats !!!Then its definitely worth celebrations! Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-26 : 12:39:08
|
CONGRATS PETER!!!you optimezed your joins well _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-26 : 12:41:14
|
JOINs? Ahhh. Yes I first thought you wrote LOINs Peter LarssonHelsingborg, Sweden |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-26 : 12:46:02
|
The query must have performance well with the optimized joins  KH |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-26 : 13:03:20
|
and LOINS _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-03-26 : 21:42:02
|
wow congrats, sagitarrius dba junior~~~Focus on problem, not solution~~~ |
 |
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-03-27 : 06:31:37
|
Wow, that's so cool Peter...congrats on the ultimate full inner join --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-03-27 : 07:07:28
|
[code]SELECT H.KidFROM Peter PINNER JOIN Spouse SON P.Ychrom = S.YchromLEFT JOIN Hospital HON (P.chromosomes + S.chromosomes) = H.kidWHERE H.birthdate BETWEEN '20071120' AND '20071130'[/code]Yes I am bored and tired this morning.Hearty congratulations Peter![Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-27 : 07:22:01
|
Thank you! Very clever query Peter LarssonHelsingborg, Sweden |
 |
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-03-27 : 12:57:08
|
Congratulations on the new version.************************Life is short. Enjoy it.************************ |
 |
|
Next Page
|