1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
SELECT test.Commentaires AS IncidentComment,
JOURNAL.[ID JOURNAL] AS IDJournal, JOURNAL.[DATE ENTREE] AS DateEntree, JOURNAL.[DATE SORTIE] AS DateSortie, JOURNAL.CODE AS CodeClient,
CASE WHEN F_COMPTET.CT_Sommeil = 1 THEN '(en sommeil)' END AS SommeilClient, F_COMPTET.CT_Intitule AS IntituleClient, F_COMPTET.CT_Telephone AS TelephoneClient, F_COMPTET.CT_Telecopie AS TelecopieClient,
JOURNAL.[REFERENCE CLIENT] AS ReferenceClient, JOURNAL.PRODUIT AS Produit, JOURNAL.Catalogue AS Catalogue, JOURNAL.CodeProduit AS CodeProduit, JOURNAL.STATUS AS STATUS, JOURNAL.[REMARQUES CLIENT] AS RemarquesClient, JOURNAL.REMARQUES AS Commentaires, JOURNAL.[N° SERIE] AS NumeroSerie, JOURNAL.[N° SERIE2] AS NumeroSerie2, JOURNAL.[DEMANDE CLIENT] AS DemandeClient, JOURNAL.[ACTION EFFECTUEE] AS ActionEffectuee, JOURNAL.[DECISION TECHNIQUE] AS DecisionTechnique, JOURNAL.[DECISION FINALE] AS DecisionFinale, JOURNAL.URGENT AS Urgent, JOURNAL.[DATE MODIFICATION] AS DateModification, JOURNAL.DECISION AS Decision,
STATUS.STATUS AS IntituleStatus,
[ACTIONS DEMANDEES].ACTION AS IntituleDemandeClient,
[ACTIONS EFFECTUEES].ACTION AS IntituleActionEffectuee,
CASE [DECISION TECHNIQUE] WHEN 1 THEN 'Garantie' WHEN 2 THEN 'Hors Garantie' ELSE '' END AS IntituleDecisionTechnique,
CASE [DECISION FINALE] WHEN 1 THEN 'Garantie' WHEN 2 THEN 'Hors Garantie' ELSE '' END AS IntituleDecisionFinale
FROM Incidents AS test
INNER JOIN CENPISA.dbo.F_COMPTET AS F_COMPTET ON F_COMPTET.CT_Num COLLATE SQL_Latin1_General_CP1_CI_AS = JOURNAL.CODE
RIGHT OUTER JOIN STATUS ON STATUS.[ID STATUS] = JOURNAL.STATUS
RIGHT OUTER JOIN [ACTIONS EFFECTUEES] ON [ACTIONS EFFECTUEES].[ID ACTION] = JOURNAL.[ACTION EFFECTUEE]
RIGHT OUTER JOIN [ACTIONS DEMANDEES] ON [ACTIONS DEMANDEES].[ID ACTION] = JOURNAL.[DEMANDE CLIENT]
RIGHT OUTER JOIN JOURNAL
WHERE (JOURNAL.[ID JOURNAL] = 14567) and test.IdAffaire = IDJournal |
Partager