[exabelux] Re: next gathering 2018 Q1

From: "bruno.vroman@xxxxxxxxxxxxxx" <bruno.vroman@xxxxxxxxxxxxxx>
To: "exabelux@xxxxxxxxxxxxx" <exabelux@xxxxxxxxxxxxx>
Date: Tue, 6 Feb 2018 11:02:57 +0000

Yes, I will join on Thu 15th!
Best regards,
Bruno

[signature_BVR]

From: exabelux-bounce@xxxxxxxxxxxxx [mailto:exabelux-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Philippe Fierens
Sent: 24 January 2018 15:09
To: exabelux@xxxxxxxxxxxxx
Subject: [exabelux] Re: next gathering 2018 Q1

excellent choice Bruno, hopefully you will be able to make it ..
thanks for the nice sql ;)
Philippe Fierens
philippe@xxxxxxxxxxxxxxxxxxxx<mailto:philippe@xxxxxxxxxxxxxxxxxxxx>

On 24 Jan 2018, at 14:24,
bruno.vroman@xxxxxxxxxxxxxx<mailto:bruno.vroman@xxxxxxxxxxxxxx> wrote:

SELECT MAX( CASE WHEN x = 1 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 2 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 3 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 4 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 5 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 6 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 7 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 8 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 9 THEN CHR( y ) END )
    || MAX( CASE WHEN x = 10 THEN CHR( y ) END )
    "Happy what?"
  FROM ( SELECT x, ((((((((((
                -0.021753748)*x
                +1.075719268)*x
                -22.74589990)*x
                +268.6524354)*x
                -1942.405473)*x
                +8856.897888)*x
                -25267.46024)*x
                +43050.87476)*x
                -39193.86764)*x
                +14321.01021) y
         FROM ( SELECT LEVEL x
                  FROM dual
                  CONNECT BY LEVEL <= 10 )
       )
;

This message and any attachments (the "message") is
intended solely for the intended addressees and is confidential.
If you receive this message in error,or are not the intended recipient(s),
please delete it and any copies from your systems and immediately notify
the sender. Any unauthorized view, use that does not comply with its purpose,
dissemination or disclosure, either whole or partial, is prohibited. Since the
internet
cannot guarantee the integrity of this message which may not be reliable, BNP
PARIBAS
(and its subsidiaries) shall not be liable for the message if modified, changed
or falsified.
Do not print this message unless it is necessary, consider the environment.

----------------------------------------------------------------------------------------------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le "message")
sont etablis a l'intention exclusive de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur ou s'il ne vous est pas destine,
merci de le detruire ainsi que toute copie de votre systeme et d'en avertir
immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de
ce message qui n'est pas conforme a sa destination, toute diffusion ou toute
publication, totale ou partielle, est interdite. L'Internet ne permettant pas
d'assurer
l'integrite de ce message electronique susceptible d'alteration, BNP Paribas
(et ses filiales) decline(nt) toute responsabilite au titre de ce message dans
l'hypothese
ou il aurait ete modifie, deforme ou falsifie.
N'imprimez ce message que si necessaire, pensez a l'environnement.

[exabelux] Re: next gathering 2018 Q1

Other related posts: