Visualizzazione dei risultati da 1 a 10 su 13

Discussione: [sql server 2008 r2]

Hybrid View

  1. #1
    posta un po' più di dati, con 2 righe non riesco a immaginarmi il film

  2. #2
    Quote Originariamente inviata da optime Visualizza il messaggio
    posta un po' pi� di dati, con 2 righe non riesco a immaginarmi il film
    con questa query recupero: 1 le turnazioni agganciate ai dipendenti 2 data e posizione di partenza del ciclo:
    codice:
    select azienda,matricola,inizio,fine,turnazione,posizione from dipen_turnazioni where azienda ='000000A153' and    (convert    (date,inizio) <= convert (date,getdate())) and    (convert    (date,fine is null or    convert (date,fine) >= convert (date,getdate()))
    azienda matricola inizio fine turn posizione
    000000A153 140844 2015-06-01 NULL S004 15
    000000A153 140845 2016-02-01 NULL S010 17
    000000A153 140846 2015-06-01 NULL S004 8
    000000A153 140847 2016-02-08 NULL S004 1
    000000A153 140848 2016-01-01 NULL S004 33
    000000A153 140849 2017-02-01 NULL S011 10
    000000A153 140850 2015-06-01 NULL S004 1
    000000A153 140851 2016-12-01 NULL S008 11
    000000A153 140852 2015-06-01 NULL S004 29
    000000A153 140853 2015-06-01 NULL S004 15
    000000A153 140854 2015-06-01 NULL S004 15
    000000A153 140856 2016-04-01 NULL S004 33
    000000A153 140857 2015-06-01 NULL S004 22
    000000A153 140860 2015-07-01 NULL S008 10
    000000A153 140862 2016-03-01 NULL S004 30
    000000A153 140863 2016-02-01 NULL S010 24
    000000A153 140869 2016-07-01 NULL S004 19
    000000A153 140870 2016-06-01 NULL GG3 24
    000000A153 140871 2015-06-01 NULL S004 22
    000000A153 140872 2015-07-01 NULL S004 3
    000000A153 140873 2017-04-01 NULL S010 6
    000000A153 140874 2015-09-21 NULL A5 1
    000000A153 140875 2016-02-01 NULL A5 1
    000000A153 140876 2015-07-01 NULL S008 3
    000000A153 140881 2016-02-01 NULL S004 22
    000000A153 140882 2016-02-01 NULL S004 15
    000000A153 140883 2015-07-01 NULL S004 31
    000000A153 140884 2015-07-01 NULL S004 10
    000000A153 140886 2017-02-01 NULL S010 31
    IncorrectSyntax

  3. #3
    Quote Originariamente inviata da IncorrectSintax Visualizza il messaggio
    con questa query recupero: 1 le turnazioni agganciate ai dipendenti 2 data e posizione di partenza del ciclo:
    codice:
    select azienda,matricola,inizio,fine,turnazione,posizione from dipen_turnazioni where azienda ='000000A153' and    (convert    (date,inizio) <= convert (date,getdate())) and    (convert    (date,fine is null or    convert (date,fine) >= convert (date,getdate()))
    azienda matricola inizio fine turn posizione
    000000A153 140844 2015-06-01 NULL S004 15
    000000A153 140845 2016-02-01 NULL S010 17
    000000A153 140846 2015-06-01 NULL S004 8
    000000A153 140847 2016-02-08 NULL S004 1
    000000A153 140848 2016-01-01 NULL S004 33
    000000A153 140849 2017-02-01 NULL S011 10
    000000A153 140850 2015-06-01 NULL S004 1
    000000A153 140851 2016-12-01 NULL S008 11
    000000A153 140852 2015-06-01 NULL S004 29
    000000A153 140853 2015-06-01 NULL S004 15
    000000A153 140854 2015-06-01 NULL S004 15
    000000A153 140856 2016-04-01 NULL S004 33
    000000A153 140857 2015-06-01 NULL S004 22
    000000A153 140860 2015-07-01 NULL S008 10
    000000A153 140862 2016-03-01 NULL S004 30
    000000A153 140863 2016-02-01 NULL S010 24
    000000A153 140869 2016-07-01 NULL S004 19
    000000A153 140870 2016-06-01 NULL GG3 24
    000000A153 140871 2015-06-01 NULL S004 22
    000000A153 140872 2015-07-01 NULL S004 3
    000000A153 140873 2017-04-01 NULL S010 6
    000000A153 140874 2015-09-21 NULL A5 1
    000000A153 140875 2016-02-01 NULL A5 1
    000000A153 140876 2015-07-01 NULL S008 3
    000000A153 140881 2016-02-01 NULL S004 22
    000000A153 140882 2016-02-01 NULL S004 15
    000000A153 140883 2015-07-01 NULL S004 31
    000000A153 140884 2015-07-01 NULL S004 10
    000000A153 140886 2017-02-01 NULL S010 31
    con questa query recupero il codice turnazione la descrizione e il numero di posizioni della turnazione dettagli della turnazione
    codice:
    select azienda,turnazione,descrizione,giorni from turnazioni

    azienda turnazione giorni
    000000A153 A5 7
    000000A153 GG3 35
    000000A153 S004 35
    000000A153 S005 28
    000000A153 S006 28
    000000A153 S007 21
    000000A153 S008 35
    000000A153 S010 35
    000000A153 S011 35
    IncorrectSyntax

  4. #4
    Quote Originariamente inviata da IncorrectSintax Visualizza il messaggio
    con questa query recupero il codice turnazione la descrizione e il numero di posizioni della turnazione dettagli della turnazione
    codice:
    select azienda,turnazione,descrizione,giorni from turnazioni

    azienda turnazione giorni
    000000A153 A5 7
    000000A153 GG3 35
    000000A153 S004 35
    000000A153 S005 28
    000000A153 S006 28
    000000A153 S007 21
    000000A153 S008 35
    000000A153 S010 35
    000000A153 S011 35
    con questa recupero l'orario di lavoro e in alternativa la causale (uno esclude l'altro) corrispondente alla posizione della turnazione


    codice:
    SELECT AZIENDA,TURNAZIONE,POSIZIONE,CAUSALE,OR_FISSO FROM TURNAZIONI_CICLI

    azienda turn pos causale or_fisso
    000000A153 A5 1 NULL X5AN
    000000A153 A5 2 NULL X5AN
    000000A153 A5 3 NULL X5AN
    000000A153 A5 4 NULL X5AN
    000000A153 A5 5 NULL X5AN
    000000A153 A5 6 RPT NULL
    000000A153 A5 7 RPT NULL
    000000A153 GG3 1 RPT NULL
    000000A153 GG3 2 NULL X5AN
    000000A153 GG3 3 NULL X5AN
    000000A153 GG3 4 NULL X5AN
    000000A153 GG3 5 NULL X5AN
    000000A153 GG3 6 NULL X5AN
    000000A153 GG3 7 RPT NULL
    000000A153 GG3 8 NULL X5AN
    000000A153 GG3 9 RPT NULL
    000000A153 GG3 10 NULL X5AN
    000000A153 GG3 11 NULL X5AN
    000000A153 GG3 12 NULL X5AN
    000000A153 GG3 13 NULL X5AN
    000000A153 GG3 14 RPT NULL
    000000A153 GG3 15 NULL X5AN
    000000A153 GG3 16 NULL X5AN
    000000A153 GG3 17 RPT NULL
    000000A153 GG3 18 NULL X5AN
    000000A153 GG3 19 NULL X5AN
    000000A153 GG3 20 NULL X5AN
    000000A153 GG3 21 RPT NULL
    000000A153 GG3 22 NULL X5AN
    000000A153 GG3 23 NULL X5AN
    000000A153 GG3 24 NULL X5AN
    000000A153 GG3 25 RPT NULL
    000000A153 GG3 26 NULL X5AN
    000000A153 GG3 27 NULL X5AN
    000000A153 GG3 28 RPT NULL
    000000A153 GG3 29 NULL X5AN
    000000A153 GG3 30 NULL X5AN
    000000A153 GG3 31 NULL X5AN
    000000A153 GG3 32 NULL X5AN
    000000A153 GG3 33 RPT NULL
    000000A153 GG3 34 RPT NULL
    000000A153 GG3 35 NULL X5AN
    000000A153 S004 1 NULL X6AN
    000000A153 S004 2 NULL X6AN
    000000A153 S004 3 NULL X6AN
    000000A153 S004 4 RPT NULL
    000000A153 S004 5 RPT NULL
    000000A153 S004 6 NULL X6AN
    000000A153 S004 7 NULL X6AN
    000000A153 S004 8 NULL X6AN
    000000A153 S004 9 RPT NULL
    000000A153 S004 10 RPT NULL
    000000A153 S004 11 NULL X6AN
    000000A153 S004 12 NULL X6AN
    000000A153 S004 13 NULL X6AN
    000000A153 S004 14 RPT NULL
    000000A153 S004 15 RPT NULL
    000000A153 S004 16 NULL X6AN
    000000A153 S004 17 NULL X6AN
    000000A153 S004 18 NULL X6AN
    000000A153 S004 19 RPT NULL
    000000A153 S004 20 RPT NULL
    000000A153 S004 21 NULL X6AN
    000000A153 S004 22 NULL X6AN
    000000A153 S004 23 NULL X6AN
    000000A153 S004 24 RPT NULL
    000000A153 S004 25 RPT NULL
    000000A153 S004 26 NULL X5AN
    000000A153 S004 27 NULL X6AN
    000000A153 S004 28 NULL X6AN
    000000A153 S004 29 RPT NULL
    000000A153 S004 30 RPT NULL
    000000A153 S004 31 NULL X6AN
    000000A153 S004 32 NULL X6AN
    000000A153 S004 33 NULL X6AN
    000000A153 S004 34 RPT NULL
    000000A153 S004 35 RPT NULL
    000000A153 S005 1 NULL X5AN
    000000A153 S005 2 NULL X5AN
    000000A153 S005 3 NULL X4AN
    000000A153 S005 4 RPT X5AN
    000000A153 S005 5 NULL X5AN
    000000A153 S005 6 NULL X5AN
    000000A153 S005 7 NULL X4AN
    000000A153 S005 8 RPT X5AN
    000000A153 S005 9 NULL X5AN
    000000A153 S005 10 NULL X5AN
    000000A153 S005 11 NULL X4AN
    000000A153 S005 12 RPT X5AN
    000000A153 S005 13 NULL X5AN
    000000A153 S005 14 NULL X5AN
    000000A153 S005 15 NULL X4AN
    000000A153 S005 16 RPT X5AN
    000000A153 S005 17 NULL X5AN
    000000A153 S005 18 NULL X5AN
    000000A153 S005 19 NULL X5AN
    000000A153 S005 20 RPT X5AN
    000000A153 S005 21 NULL X5AN
    000000A153 S005 22 NULL X5AN
    000000A153 S005 23 NULL X4AN
    000000A153 S005 24 RPT X5AN
    000000A153 S005 25 NULL X5AN
    000000A153 S005 26 NULL X5AN
    000000A153 S005 27 NULL X5AN
    000000A153 S005 28 RPT X5AN
    000000A153 S006 1 NULL X6AN
    000000A153 S006 2 NULL X6AN
    000000A153 S006 3 NULL X6AN
    000000A153 S006 4 RPT X6AN
    000000A153 S006 5 NULL X6AN
    000000A153 S006 6 NULL X5AN
    000000A153 S006 7 NULL X5AN
    000000A153 S006 8 RPT X6AN
    000000A153 S006 9 NULL X6AN
    000000A153 S006 10 NULL X6AN
    000000A153 S006 11 NULL X6AN
    000000A153 S006 12 RPT X6AN
    000000A153 S006 13 NULL X5AN
    000000A153 S006 14 NULL X5AN
    000000A153 S006 15 NULL X6AN
    000000A153 S006 16 RPT X6AN
    000000A153 S006 17 NULL X6AN
    000000A153 S006 18 NULL X6AN
    000000A153 S006 19 NULL X6AN
    000000A153 S006 20 RPT X6AN
    000000A153 S006 21 NULL X5AN
    000000A153 S006 22 NULL X6AN
    000000A153 S006 23 NULL X6AN
    000000A153 S006 24 RPT X6AN
    000000A153 S006 25 NULL X6AN
    000000A153 S006 26 NULL X6AN
    000000A153 S006 27 NULL X5AN
    000000A153 S006 28 RPT X6AN
    000000A153 S007 1 NULL X5GN
    000000A153 S007 2 NULL X5GN
    000000A153 S007 3 RPT NULL
    000000A153 S007 4 NULL X5GN
    000000A153 S007 5 NULL X5GN
    000000A153 S007 6 RPT NULL
    000000A153 S007 7 RPT NULL
    000000A153 S007 8 NULL X5GN
    000000A153 S007 9 RPT NULL
    000000A153 S007 10 NULL X5GN
    000000A153 S007 11 NULL X5GN
    000000A153 S007 12 RPT NULL
    000000A153 S007 13 NULL X5GN
    000000A153 S007 14 NULL X5GN
    000000A153 S007 15 RPT NULL
    000000A153 S007 16 NULL X5GN
    000000A153 S007 17 NULL X5GN
    000000A153 S007 18 RPT NULL
    000000A153 S007 19 NULL X5GN
    000000A153 S007 20 NULL X5GN
    000000A153 S007 21 RPT NULL
    000000A153 S008 1 NULL X6AN
    000000A153 S008 2 NULL X6AN
    000000A153 S008 3 NULL X6AN
    000000A153 S008 4 NULL X6AN
    000000A153 S008 5 NULL X6AN
    000000A153 S008 6 RPT X6AN
    000000A153 S008 7 RPT X6AN
    000000A153 S008 8 NULL X6AN
    000000A153 S008 9 NULL X6AN
    000000A153 S008 10 NULL X6AN
    000000A153 S008 11 RPT X6AN
    000000A153 S008 12 RPT X6AN
    000000A153 S008 13 NULL X6AN
    000000A153 S008 14 NULL X6AN
    000000A153 S008 15 NULL X6AN
    000000A153 S008 16 NULL X6AN
    000000A153 S008 17 RPT X6AN
    000000A153 S008 18 NULL X6AN
    000000A153 S008 19 NULL X6AN
    000000A153 S008 20 NULL X6AN
    000000A153 S008 21 RPT X6AN
    000000A153 S008 22 NULL X6AN
    000000A153 S008 23 RPT X6AN
    000000A153 S008 24 NULL X6AN
    000000A153 S008 25 NULL X6AN
    000000A153 S008 26 NULL X6AN
    000000A153 S008 27 NULL X6AN
    000000A153 S008 28 RPT X6AN
    000000A153 S008 29 RPT X6AN
    000000A153 S008 30 NULL X6AN
    000000A153 S008 31 NULL X6AN
    000000A153 S008 32 NULL X6AN
    000000A153 S008 33 NULL X6AN
    000000A153 S008 34 NULL X6AN
    000000A153 S008 35 RPT X6AN
    000000A153 S010 1 NULL X6AN
    000000A153 S010 2 NULL X6AN
    000000A153 S010 3 NULL X6AN
    000000A153 S010 4 RPT NULL
    000000A153 S010 5 RPT NULL
    000000A153 S010 6 NULL X6AN
    000000A153 S010 7 NULL X6AN
    000000A153 S010 8 NULL X6AN
    000000A153 S010 9 RPT NULL
    000000A153 S010 10 RPT NULL
    000000A153 S010 11 NULL X6AN
    000000A153 S010 12 NULL X6AN
    000000A153 S010 13 NULL X6AN
    000000A153 S010 14 RPT NULL
    000000A153 S010 15 RPT NULL
    000000A153 S010 16 NULL X6AN
    000000A153 S010 17 NULL X6AN
    000000A153 S010 18 NULL X5AN
    000000A153 S010 19 RPT NULL
    000000A153 S010 20 RPT NULL
    000000A153 S010 21 NULL X6AN
    000000A153 S010 22 NULL X6AN
    000000A153 S010 23 NULL X6AN
    000000A153 S010 24 RPT NULL
    000000A153 S010 25 RPT NULL
    000000A153 S010 26 NULL X6AN
    000000A153 S010 27 NULL X6AN
    000000A153 S010 28 NULL X6AN
    000000A153 S010 29 RPT NULL
    000000A153 S010 30 RPT NULL
    000000A153 S010 31 NULL X6AN
    000000A153 S010 32 NULL X6AN
    000000A153 S010 33 NULL X6AN
    000000A153 S010 34 RPT NULL
    000000A153 S010 35 RPT NULL
    000000A153 S011 1 NULL X5AN
    000000A153 S011 2 NULL X5AN
    000000A153 S011 3 NULL X5AN
    000000A153 S011 4 NULL X5AN
    000000A153 S011 5 NULL X5AN
    000000A153 S011 6 RPT NULL
    000000A153 S011 7 RPT NULL
    000000A153 S011 8 NULL X5AN
    000000A153 S011 9 NULL X5AN
    000000A153 S011 10 NULL X5AN
    000000A153 S011 11 RPT NULL
    000000A153 S011 12 RPT NULL
    000000A153 S011 13 NULL X5AN
    000000A153 S011 14 NULL X5AN
    000000A153 S011 15 NULL X5AN
    000000A153 S011 16 NULL X5AN
    000000A153 S011 17 RPT NULL
    000000A153 S011 18 NULL X5AN
    000000A153 S011 19 NULL X5AN
    000000A153 S011 20 NULL X5AN
    000000A153 S011 21 RPT NULL
    000000A153 S011 22 NULL X5AN
    000000A153 S011 23 RPT NULL
    000000A153 S011 24 NULL X5AN
    000000A153 S011 25 NULL X5AN
    000000A153 S011 26 NULL X5AN
    000000A153 S011 27 NULL X5AN
    000000A153 S011 28 RPT NULL
    000000A153 S011 29 RPT NULL
    000000A153 S011 30 NULL X5AN
    000000A153 S011 31 NULL X5AN
    000000A153 S011 32 NULL X5AN
    000000A153 S011 33 NULL X5AN
    000000A153 S011 34 NULL X5AN
    000000A153 S011 35 RPT NULL
    IncorrectSyntax

  5. #5
    Quote Originariamente inviata da IncorrectSintax Visualizza il messaggio
    con questa recupero l'orario di lavoro e in alternativa la causale (uno esclude l'altro) corrispondente alla posizione della turnazione


    codice:
    SELECT AZIENDA,TURNAZIONE,POSIZIONE,CAUSALE,OR_FISSO FROM TURNAZIONI_CICLI

    azienda turn pos causale or_fisso
    000000A153 A5 1 NULL X5AN
    000000A153 A5 2 NULL X5AN
    000000A153 A5 3 NULL X5AN
    000000A153 A5 4 NULL X5AN
    000000A153 A5 5 NULL X5AN
    000000A153 A5 6 RPT NULL
    000000A153 A5 7 RPT NULL
    000000A153 GG3 1 RPT NULL
    000000A153 GG3 2 NULL X5AN
    000000A153 GG3 3 NULL X5AN
    000000A153 GG3 4 NULL X5AN
    000000A153 GG3 5 NULL X5AN
    000000A153 GG3 6 NULL X5AN
    000000A153 GG3 7 RPT NULL
    000000A153 GG3 8 NULL X5AN
    000000A153 GG3 9 RPT NULL
    000000A153 GG3 10 NULL X5AN
    000000A153 GG3 11 NULL X5AN
    000000A153 GG3 12 NULL X5AN
    000000A153 GG3 13 NULL X5AN
    000000A153 GG3 14 RPT NULL
    000000A153 GG3 15 NULL X5AN
    000000A153 GG3 16 NULL X5AN
    000000A153 GG3 17 RPT NULL
    000000A153 GG3 18 NULL X5AN
    000000A153 GG3 19 NULL X5AN
    000000A153 GG3 20 NULL X5AN
    000000A153 GG3 21 RPT NULL
    000000A153 GG3 22 NULL X5AN
    000000A153 GG3 23 NULL X5AN
    000000A153 GG3 24 NULL X5AN
    000000A153 GG3 25 RPT NULL
    000000A153 GG3 26 NULL X5AN
    000000A153 GG3 27 NULL X5AN
    000000A153 GG3 28 RPT NULL
    000000A153 GG3 29 NULL X5AN
    000000A153 GG3 30 NULL X5AN
    000000A153 GG3 31 NULL X5AN
    000000A153 GG3 32 NULL X5AN
    000000A153 GG3 33 RPT NULL
    000000A153 GG3 34 RPT NULL
    000000A153 GG3 35 NULL X5AN
    000000A153 S004 1 NULL X6AN
    000000A153 S004 2 NULL X6AN
    000000A153 S004 3 NULL X6AN
    000000A153 S004 4 RPT NULL
    000000A153 S004 5 RPT NULL
    000000A153 S004 6 NULL X6AN
    000000A153 S004 7 NULL X6AN
    000000A153 S004 8 NULL X6AN
    000000A153 S004 9 RPT NULL
    000000A153 S004 10 RPT NULL
    000000A153 S004 11 NULL X6AN
    000000A153 S004 12 NULL X6AN
    000000A153 S004 13 NULL X6AN
    000000A153 S004 14 RPT NULL
    000000A153 S004 15 RPT NULL
    000000A153 S004 16 NULL X6AN
    000000A153 S004 17 NULL X6AN
    000000A153 S004 18 NULL X6AN
    000000A153 S004 19 RPT NULL
    000000A153 S004 20 RPT NULL
    000000A153 S004 21 NULL X6AN
    000000A153 S004 22 NULL X6AN
    000000A153 S004 23 NULL X6AN
    000000A153 S004 24 RPT NULL
    000000A153 S004 25 RPT NULL
    000000A153 S004 26 NULL X5AN
    000000A153 S004 27 NULL X6AN
    000000A153 S004 28 NULL X6AN
    000000A153 S004 29 RPT NULL
    000000A153 S004 30 RPT NULL
    000000A153 S004 31 NULL X6AN
    000000A153 S004 32 NULL X6AN
    000000A153 S004 33 NULL X6AN
    000000A153 S004 34 RPT NULL
    000000A153 S004 35 RPT NULL
    000000A153 S005 1 NULL X5AN
    000000A153 S005 2 NULL X5AN
    000000A153 S005 3 NULL X4AN
    000000A153 S005 4 RPT X5AN
    000000A153 S005 5 NULL X5AN
    000000A153 S005 6 NULL X5AN
    000000A153 S005 7 NULL X4AN
    000000A153 S005 8 RPT X5AN
    000000A153 S005 9 NULL X5AN
    000000A153 S005 10 NULL X5AN
    000000A153 S005 11 NULL X4AN
    000000A153 S005 12 RPT X5AN
    000000A153 S005 13 NULL X5AN
    000000A153 S005 14 NULL X5AN
    000000A153 S005 15 NULL X4AN
    000000A153 S005 16 RPT X5AN
    000000A153 S005 17 NULL X5AN
    000000A153 S005 18 NULL X5AN
    000000A153 S005 19 NULL X5AN
    000000A153 S005 20 RPT X5AN
    000000A153 S005 21 NULL X5AN
    000000A153 S005 22 NULL X5AN
    000000A153 S005 23 NULL X4AN
    000000A153 S005 24 RPT X5AN
    000000A153 S005 25 NULL X5AN
    000000A153 S005 26 NULL X5AN
    000000A153 S005 27 NULL X5AN
    000000A153 S005 28 RPT X5AN
    000000A153 S006 1 NULL X6AN
    000000A153 S006 2 NULL X6AN
    000000A153 S006 3 NULL X6AN
    000000A153 S006 4 RPT X6AN
    000000A153 S006 5 NULL X6AN
    000000A153 S006 6 NULL X5AN
    000000A153 S006 7 NULL X5AN
    000000A153 S006 8 RPT X6AN
    000000A153 S006 9 NULL X6AN
    000000A153 S006 10 NULL X6AN
    000000A153 S006 11 NULL X6AN
    000000A153 S006 12 RPT X6AN
    000000A153 S006 13 NULL X5AN
    000000A153 S006 14 NULL X5AN
    000000A153 S006 15 NULL X6AN
    000000A153 S006 16 RPT X6AN
    000000A153 S006 17 NULL X6AN
    000000A153 S006 18 NULL X6AN
    000000A153 S006 19 NULL X6AN
    000000A153 S006 20 RPT X6AN
    000000A153 S006 21 NULL X5AN
    000000A153 S006 22 NULL X6AN
    000000A153 S006 23 NULL X6AN
    000000A153 S006 24 RPT X6AN
    000000A153 S006 25 NULL X6AN
    000000A153 S006 26 NULL X6AN
    000000A153 S006 27 NULL X5AN
    000000A153 S006 28 RPT X6AN
    000000A153 S007 1 NULL X5GN
    000000A153 S007 2 NULL X5GN
    000000A153 S007 3 RPT NULL
    000000A153 S007 4 NULL X5GN
    000000A153 S007 5 NULL X5GN
    000000A153 S007 6 RPT NULL
    000000A153 S007 7 RPT NULL
    000000A153 S007 8 NULL X5GN
    000000A153 S007 9 RPT NULL
    000000A153 S007 10 NULL X5GN
    000000A153 S007 11 NULL X5GN
    000000A153 S007 12 RPT NULL
    000000A153 S007 13 NULL X5GN
    000000A153 S007 14 NULL X5GN
    000000A153 S007 15 RPT NULL
    000000A153 S007 16 NULL X5GN
    000000A153 S007 17 NULL X5GN
    000000A153 S007 18 RPT NULL
    000000A153 S007 19 NULL X5GN
    000000A153 S007 20 NULL X5GN
    000000A153 S007 21 RPT NULL
    000000A153 S008 1 NULL X6AN
    000000A153 S008 2 NULL X6AN
    000000A153 S008 3 NULL X6AN
    000000A153 S008 4 NULL X6AN
    000000A153 S008 5 NULL X6AN
    000000A153 S008 6 RPT X6AN
    000000A153 S008 7 RPT X6AN
    000000A153 S008 8 NULL X6AN
    000000A153 S008 9 NULL X6AN
    000000A153 S008 10 NULL X6AN
    000000A153 S008 11 RPT X6AN
    000000A153 S008 12 RPT X6AN
    000000A153 S008 13 NULL X6AN
    000000A153 S008 14 NULL X6AN
    000000A153 S008 15 NULL X6AN
    000000A153 S008 16 NULL X6AN
    000000A153 S008 17 RPT X6AN
    000000A153 S008 18 NULL X6AN
    000000A153 S008 19 NULL X6AN
    000000A153 S008 20 NULL X6AN
    000000A153 S008 21 RPT X6AN
    000000A153 S008 22 NULL X6AN
    000000A153 S008 23 RPT X6AN
    000000A153 S008 24 NULL X6AN
    000000A153 S008 25 NULL X6AN
    000000A153 S008 26 NULL X6AN
    000000A153 S008 27 NULL X6AN
    000000A153 S008 28 RPT X6AN
    000000A153 S008 29 RPT X6AN
    000000A153 S008 30 NULL X6AN
    000000A153 S008 31 NULL X6AN
    000000A153 S008 32 NULL X6AN
    000000A153 S008 33 NULL X6AN
    000000A153 S008 34 NULL X6AN
    000000A153 S008 35 RPT X6AN
    000000A153 S010 1 NULL X6AN
    000000A153 S010 2 NULL X6AN
    000000A153 S010 3 NULL X6AN
    000000A153 S010 4 RPT NULL
    000000A153 S010 5 RPT NULL
    000000A153 S010 6 NULL X6AN
    000000A153 S010 7 NULL X6AN
    000000A153 S010 8 NULL X6AN
    000000A153 S010 9 RPT NULL
    000000A153 S010 10 RPT NULL
    000000A153 S010 11 NULL X6AN
    000000A153 S010 12 NULL X6AN
    000000A153 S010 13 NULL X6AN
    000000A153 S010 14 RPT NULL
    000000A153 S010 15 RPT NULL
    000000A153 S010 16 NULL X6AN
    000000A153 S010 17 NULL X6AN
    000000A153 S010 18 NULL X5AN
    000000A153 S010 19 RPT NULL
    000000A153 S010 20 RPT NULL
    000000A153 S010 21 NULL X6AN
    000000A153 S010 22 NULL X6AN
    000000A153 S010 23 NULL X6AN
    000000A153 S010 24 RPT NULL
    000000A153 S010 25 RPT NULL
    000000A153 S010 26 NULL X6AN
    000000A153 S010 27 NULL X6AN
    000000A153 S010 28 NULL X6AN
    000000A153 S010 29 RPT NULL
    000000A153 S010 30 RPT NULL
    000000A153 S010 31 NULL X6AN
    000000A153 S010 32 NULL X6AN
    000000A153 S010 33 NULL X6AN
    000000A153 S010 34 RPT NULL
    000000A153 S010 35 RPT NULL
    000000A153 S011 1 NULL X5AN
    000000A153 S011 2 NULL X5AN
    000000A153 S011 3 NULL X5AN
    000000A153 S011 4 NULL X5AN
    000000A153 S011 5 NULL X5AN
    000000A153 S011 6 RPT NULL
    000000A153 S011 7 RPT NULL
    000000A153 S011 8 NULL X5AN
    000000A153 S011 9 NULL X5AN
    000000A153 S011 10 NULL X5AN
    000000A153 S011 11 RPT NULL
    000000A153 S011 12 RPT NULL
    000000A153 S011 13 NULL X5AN
    000000A153 S011 14 NULL X5AN
    000000A153 S011 15 NULL X5AN
    000000A153 S011 16 NULL X5AN
    000000A153 S011 17 RPT NULL
    000000A153 S011 18 NULL X5AN
    000000A153 S011 19 NULL X5AN
    000000A153 S011 20 NULL X5AN
    000000A153 S011 21 RPT NULL
    000000A153 S011 22 NULL X5AN
    000000A153 S011 23 RPT NULL
    000000A153 S011 24 NULL X5AN
    000000A153 S011 25 NULL X5AN
    000000A153 S011 26 NULL X5AN
    000000A153 S011 27 NULL X5AN
    000000A153 S011 28 RPT NULL
    000000A153 S011 29 RPT NULL
    000000A153 S011 30 NULL X5AN
    000000A153 S011 31 NULL X5AN
    000000A153 S011 32 NULL X5AN
    000000A153 S011 33 NULL X5AN
    000000A153 S011 34 NULL X5AN
    000000A153 S011 35 RPT NULL
    Optime,
    scusa mi è partito un paste sbagliato ... hai tutti gli elementi ora?
    IncorrectSyntax

  6. #6
    con questa recupero l'orario di lavoro e in alternativa la causale (uno esclude l'altro) corrispondente alla posizione della turnazione


    codice:
    SELECT AZIENDA,TURNAZIONE,POSIZIONE,CAUSALE,OR_FISSO FROM TURNAZIONI_CICLI

    azienda turn pos causale or_fisso
    000000A153 A5 1 NULL X5AN
    000000A153 A5 2 NULL X5AN
    000000A153 A5 3 NULL X5AN
    000000A153 A5 4 NULL X5AN
    000000A153 A5 5 NULL X5AN
    000000A153 A5 6 RPT NULL
    000000A153 A5 7 RPT NULL
    000000A153 GG3 1 RPT NULL
    000000A153 GG3 2 NULL X5AN
    000000A153 GG3 3 NULL X5AN
    000000A153 GG3 4 NULL X5AN
    000000A153 GG3 5 NULL X5AN
    000000A153 GG3 6 NULL X5AN
    000000A153 GG3 7 RPT NULL
    000000A153 GG3 8 NULL X5AN
    000000A153 GG3 9 RPT NULL
    000000A153 GG3 10 NULL X5AN
    000000A153 GG3 11 NULL X5AN
    000000A153 GG3 12 NULL X5AN
    000000A153 GG3 13 NULL X5AN
    000000A153 GG3 14 RPT NULL
    000000A153 GG3 15 NULL X5AN
    000000A153 GG3 16 NULL X5AN
    000000A153 GG3 17 RPT NULL
    000000A153 GG3 18 NULL X5AN
    000000A153 GG3 19 NULL X5AN
    000000A153 GG3 20 NULL X5AN
    000000A153 GG3 21 RPT NULL
    000000A153 GG3 22 NULL X5AN
    000000A153 GG3 23 NULL X5AN
    000000A153 GG3 24 NULL X5AN
    000000A153 GG3 25 RPT NULL
    000000A153 GG3 26 NULL X5AN
    000000A153 GG3 27 NULL X5AN
    000000A153 GG3 28 RPT NULL
    000000A153 GG3 29 NULL X5AN
    000000A153 GG3 30 NULL X5AN
    000000A153 GG3 31 NULL X5AN
    000000A153 GG3 32 NULL X5AN
    000000A153 GG3 33 RPT NULL
    000000A153 GG3 34 RPT NULL
    000000A153 GG3 35 NULL X5AN
    000000A153 S004 1 NULL X6AN
    000000A153 S004 2 NULL X6AN
    000000A153 S004 3 NULL X6AN
    000000A153 S004 4 RPT NULL
    000000A153 S004 5 RPT NULL
    000000A153 S004 6 NULL X6AN
    000000A153 S004 7 NULL X6AN
    000000A153 S004 8 NULL X6AN
    000000A153 S004 9 RPT NULL
    000000A153 S004 10 RPT NULL
    000000A153 S004 11 NULL X6AN
    000000A153 S004 12 NULL X6AN
    000000A153 S004 13 NULL X6AN
    000000A153 S004 14 RPT NULL
    000000A153 S004 15 RPT NULL
    000000A153 S004 16 NULL X6AN
    000000A153 S004 17 NULL X6AN
    000000A153 S004 18 NULL X6AN
    000000A153 S004 19 RPT NULL
    000000A153 S004 20 RPT NULL
    000000A153 S004 21 NULL X6AN
    000000A153 S004 22 NULL X6AN
    000000A153 S004 23 NULL X6AN
    000000A153 S004 24 RPT NULL
    000000A153 S004 25 RPT NULL
    000000A153 S004 26 NULL X5AN
    000000A153 S004 27 NULL X6AN
    000000A153 S004 28 NULL X6AN
    000000A153 S004 29 RPT NULL
    000000A153 S004 30 RPT NULL
    000000A153 S004 31 NULL X6AN
    000000A153 S004 32 NULL X6AN
    000000A153 S004 33 NULL X6AN
    000000A153 S004 34 RPT NULL
    000000A153 S004 35 RPT NULL
    000000A153 S005 1 NULL X5AN
    000000A153 S005 2 NULL X5AN
    000000A153 S005 3 NULL X4AN
    000000A153 S005 4 RPT X5AN
    000000A153 S005 5 NULL X5AN
    000000A153 S005 6 NULL X5AN
    000000A153 S005 7 NULL X4AN
    000000A153 S005 8 RPT X5AN
    000000A153 S005 9 NULL X5AN
    000000A153 S005 10 NULL X5AN
    000000A153 S005 11 NULL X4AN
    000000A153 S005 12 RPT X5AN
    000000A153 S005 13 NULL X5AN
    000000A153 S005 14 NULL X5AN
    000000A153 S005 15 NULL X4AN
    000000A153 S005 16 RPT X5AN
    000000A153 S005 17 NULL X5AN
    000000A153 S005 18 NULL X5AN
    000000A153 S005 19 NULL X5AN
    000000A153 S005 20 RPT X5AN
    000000A153 S005 21 NULL X5AN
    000000A153 S005 22 NULL X5AN
    000000A153 S005 23 NULL X4AN
    000000A153 S005 24 RPT X5AN
    000000A153 S005 25 NULL X5AN
    000000A153 S005 26 NULL X5AN
    000000A153 S005 27 NULL X5AN
    000000A153 S005 28 RPT X5AN
    000000A153 S006 1 NULL X6AN
    000000A153 S006 2 NULL X6AN
    000000A153 S006 3 NULL X6AN
    000000A153 S006 4 RPT X6AN
    000000A153 S006 5 NULL X6AN
    000000A153 S006 6 NULL X5AN
    000000A153 S006 7 NULL X5AN
    000000A153 S006 8 RPT X6AN
    000000A153 S006 9 NULL X6AN
    000000A153 S006 10 NULL X6AN
    000000A153 S006 11 NULL X6AN
    000000A153 S006 12 RPT X6AN
    000000A153 S006 13 NULL X5AN
    000000A153 S006 14 NULL X5AN
    000000A153 S006 15 NULL X6AN
    000000A153 S006 16 RPT X6AN
    000000A153 S006 17 NULL X6AN
    000000A153 S006 18 NULL X6AN
    000000A153 S006 19 NULL X6AN
    000000A153 S006 20 RPT X6AN
    000000A153 S006 21 NULL X5AN
    000000A153 S006 22 NULL X6AN
    000000A153 S006 23 NULL X6AN
    000000A153 S006 24 RPT X6AN
    000000A153 S006 25 NULL X6AN
    000000A153 S006 26 NULL X6AN
    000000A153 S006 27 NULL X5AN
    000000A153 S006 28 RPT X6AN
    000000A153 S007 1 NULL X5GN
    000000A153 S007 2 NULL X5GN
    000000A153 S007 3 RPT NULL
    000000A153 S007 4 NULL X5GN
    000000A153 S007 5 NULL X5GN
    000000A153 S007 6 RPT NULL
    000000A153 S007 7 RPT NULL
    000000A153 S007 8 NULL X5GN
    000000A153 S007 9 RPT NULL
    000000A153 S007 10 NULL X5GN
    000000A153 S007 11 NULL X5GN
    000000A153 S007 12 RPT NULL
    000000A153 S007 13 NULL X5GN
    000000A153 S007 14 NULL X5GN
    000000A153 S007 15 RPT NULL
    000000A153 S007 16 NULL X5GN
    000000A153 S007 17 NULL X5GN
    000000A153 S007 18 RPT NULL
    000000A153 S007 19 NULL X5GN
    000000A153 S007 20 NULL X5GN
    000000A153 S007 21 RPT NULL
    000000A153 S008 1 NULL X6AN
    000000A153 S008 2 NULL X6AN
    000000A153 S008 3 NULL X6AN
    000000A153 S008 4 NULL X6AN
    000000A153 S008 5 NULL X6AN
    000000A153 S008 6 RPT X6AN
    000000A153 S008 7 RPT X6AN
    000000A153 S008 8 NULL X6AN
    000000A153 S008 9 NULL X6AN
    000000A153 S008 10 NULL X6AN
    000000A153 S008 11 RPT X6AN
    000000A153 S008 12 RPT X6AN
    000000A153 S008 13 NULL X6AN
    000000A153 S008 14 NULL X6AN
    000000A153 S008 15 NULL X6AN
    000000A153 S008 16 NULL X6AN
    000000A153 S008 17 RPT X6AN
    000000A153 S008 18 NULL X6AN
    000000A153 S008 19 NULL X6AN
    000000A153 S008 20 NULL X6AN
    000000A153 S008 21 RPT X6AN
    000000A153 S008 22 NULL X6AN
    000000A153 S008 23 RPT X6AN
    000000A153 S008 24 NULL X6AN
    000000A153 S008 25 NULL X6AN
    000000A153 S008 26 NULL X6AN
    000000A153 S008 27 NULL X6AN
    000000A153 S008 28 RPT X6AN
    000000A153 S008 29 RPT X6AN
    000000A153 S008 30 NULL X6AN
    000000A153 S008 31 NULL X6AN
    000000A153 S008 32 NULL X6AN
    000000A153 S008 33 NULL X6AN
    000000A153 S008 34 NULL X6AN
    000000A153 S008 35 RPT X6AN
    000000A153 S010 1 NULL X6AN
    000000A153 S010 2 NULL X6AN
    000000A153 S010 3 NULL X6AN
    000000A153 S010 4 RPT NULL
    000000A153 S010 5 RPT NULL
    000000A153 S010 6 NULL X6AN
    000000A153 S010 7 NULL X6AN
    000000A153 S010 8 NULL X6AN
    000000A153 S010 9 RPT NULL
    000000A153 S010 10 RPT NULL
    000000A153 S010 11 NULL X6AN
    000000A153 S010 12 NULL X6AN
    000000A153 S010 13 NULL X6AN
    000000A153 S010 14 RPT NULL
    000000A153 S010 15 RPT NULL
    000000A153 S010 16 NULL X6AN
    000000A153 S010 17 NULL X6AN
    000000A153 S010 18 NULL X5AN
    000000A153 S010 19 RPT NULL
    000000A153 S010 20 RPT NULL
    000000A153 S010 21 NULL X6AN
    000000A153 S010 22 NULL X6AN
    000000A153 S010 23 NULL X6AN
    000000A153 S010 24 RPT NULL
    000000A153 S010 25 RPT NULL
    000000A153 S010 26 NULL X6AN
    000000A153 S010 27 NULL X6AN
    000000A153 S010 28 NULL X6AN
    000000A153 S010 29 RPT NULL
    000000A153 S010 30 RPT NULL
    000000A153 S010 31 NULL X6AN
    000000A153 S010 32 NULL X6AN
    000000A153 S010 33 NULL X6AN
    000000A153 S010 34 RPT NULL
    000000A153 S010 35 RPT NULL
    000000A153 S011 1 NULL X5AN
    000000A153 S011 2 NULL X5AN
    000000A153 S011 3 NULL X5AN
    000000A153 S011 4 NULL X5AN
    000000A153 S011 5 NULL X5AN
    000000A153 S011 6 RPT NULL
    000000A153 S011 7 RPT NULL
    000000A153 S011 8 NULL X5AN
    000000A153 S011 9 NULL X5AN
    000000A153 S011 10 NULL X5AN
    000000A153 S011 11 RPT NULL
    000000A153 S011 12 RPT NULL
    000000A153 S011 13 NULL X5AN
    000000A153 S011 14 NULL X5AN
    000000A153 S011 15 NULL X5AN
    000000A153 S011 16 NULL X5AN
    000000A153 S011 17 RPT NULL
    000000A153 S011 18 NULL X5AN
    000000A153 S011 19 NULL X5AN
    000000A153 S011 20 NULL X5AN
    000000A153 S011 21 RPT NULL
    000000A153 S011 22 NULL X5AN
    000000A153 S011 23 RPT NULL
    000000A153 S011 24 NULL X5AN
    000000A153 S011 25 NULL X5AN
    000000A153 S011 26 NULL X5AN
    000000A153 S011 27 NULL X5AN
    000000A153 S011 28 RPT NULL
    000000A153 S011 29 RPT NULL
    000000A153 S011 30 NULL X5AN
    000000A153 S011 31 NULL X5AN
    000000A153 S011 32 NULL X5AN
    000000A153 S011 33 NULL X5AN
    000000A153 S011 34 NULL X5AN
    000000A153 S011 35 RPT NULL
    IncorrectSyntax

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2026 vBulletin Solutions, Inc. All rights reserved.