Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LEFT OUTER JOIN (
- SELECT dwh_prozess_id
- , ONKZ
- , TN_NUM
- , Aspez_Id
- , Tarif_Cd
- , Lokation_Id
- , VWArt_Id
- , Geografische_RFN_JN
- , Herkunft_Cd
- -- , .... Felder, die noch benötigt werden
- , RANK (Aspez_Id) AS Prio
- FROM DB09_Prozess.TB0911_Basis_Konfiguration
- WHERE arbeit_cd = 'Einrichten'
- AND phase_cd = 'Durchgeführt'
- ) AS TB0911
- ON t1.DWH_Prozess_Id = TB0911.DWH_Prozess_Id
- AND t1.Herkunft_Cd = TB0911.Herkunft_Cd
- SELECT dwh_prozess_id
- , ONKZ
- , TN_NUM
- , Aspez_Id
- , Tarif_Cd
- , Lokation_Id
- , VWArt_Id
- , Geografische_RFN_JN
- , Herkunft_Cd
- -- , .... Felder, die noch benötigt werden
- --, RANK (Aspez_Id) AS Prio
- , ROW_NUMBER() OVER(PARTITION BY {partition group} /* PARTITION BY is optional */
- ORDER BY {ordering group}) AS Prio
- FROM DB09_Prozess.TB0911_Basis_Konfiguration
- WHERE arbeit_cd = 'Einrichten'
- AND phase_cd = 'Durchgeführt'
- QUALIFY Prio = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement