Remove the all comments from a sql view in azure DW

CREATE VIEW [dimension].[v_dim_customer] as
SELECT
— primary key
KNA1.fk_MANDT_KUNNR AS sk_customer,
KNA1.bk_MANDT_mandant,
— attribut
KNA1.[NAME1_nom],
KNA1.[NAME2_nom_2],
— KNA1.[DEAR1_concurrents],
–KNA1.[DEAR2_responsable_adv],

 ----- /*flag client interne/externe*/-----
 flag_ext_int.externe_interne_code, 

 /* flag client interne/externe niveau 2 (détaillé : intra groupe / intra société / externe)*/
 flag_ext_int.externe_interne_level_2_code, 

 --   date pour delta
 --CY.max_slt_datetime

-- add --18/12/2023
 FROM [e3p].[KNA1] KNA1
 LEFT OUTER JOIN [e3p].T005T T005T 
 ON KNA1.[fk_MANDT_LAND1] = T005T.[fk_MANDT_LAND1]
 AND T005T.[bk_SPRAS_code_langue] = N'F' -- français
 LEFT OUTER JOIN [e3p].T016T  
 ON KNA1.[fk_MANDT_BRSCH] = T016T.[fk_MANDT_BRSCH]
 --AND KNA1.[SPRAS_code_langue] = T016T.[bk_SPRAS_code_langue]
 AND T016T.[bk_SPRAS_code_langue] = N'F' -- français

— modif ska 03/12 : ajout delai moyen de paiement, credit autorisé et recommendé
— LEFT OUTER JOIN [e3p].[v_KNKK_fr_compute] as KNKK ON KNA1.bk_MANDT_mandant = KNKK.bk_MANDT_mandant
–AND KNA1.bk_KUNNR_client = KNKK.bk_KUNNR_client

You need to sign in to view this answers

Related Post