SQL - Seznam neodeslaných EET zpráv

Comments (...)

SQL - Seznam neodeslaných EET zpráv

 

SELECT

   *

FROM

(

SELECT

   'R1' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R1

UNION ALL

SELECT

   'R2' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R2

UNION ALL

SELECT

   'R3' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R3

UNION ALL

SELECT

   'R4' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R4

UNION ALL

SELECT

   'R5' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R5

UNION ALL

SELECT

   'R6' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R6

UNION ALL

SELECT

   'R7' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R7

UNION ALL

SELECT

   'R8' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_R8

UNION ALL

SELECT

   'O1' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O1

UNION ALL

SELECT

   'O2' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O2

UNION ALL

SELECT

   'O3' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O3

UNION ALL

SELECT

   'O4' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O4

UNION ALL

SELECT

   'O5' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O5

UNION ALL

SELECT

   'O6' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O6

UNION ALL

SELECT

   'O7' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O7

UNION ALL

SELECT

   'O8' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_O8

UNION ALL

SELECT

   'V1' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V1

UNION ALL

SELECT

   'V2' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V2

UNION ALL

SELECT

   'V3' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V3

UNION ALL

SELECT

   'V4' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V4

UNION ALL

SELECT

   'V5' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V5

UNION ALL

SELECT

   'V6' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V6

UNION ALL

SELECT

   'V7' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V7

UNION ALL

SELECT

   'V8' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_V8

UNION ALL

SELECT

   'HO' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_HO

UNION ALL

SELECT

   'CA' AS Tabulka,

   CASE WHEN (UAdmin IS NULL) THEN 0 ELSE UAdmin END AS EET,

   POkres AS ms,

   (CAST(CURRENT_TIMESTAMP AS FLOAT)-CAST(DatumExpedice AS FLOAT))*24.0 AS Hodin,

   CisloDokladu,

   DatumExpedice AS DatumEET,

   DatumPosledniPenalizace AS DatumEETOK,

   DatumPoslednihoSmiru AS DatumEETNeodeslo

FROM

   XXG_X_CA

) AS x

WHERE

   EET<0

ORDER BY

   EET,

   Hodin DESC

 

 

 

 

Comments (...)

Created with Help & Manual 6 and styled with Premium Pack 2.0