1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
SELECT T3.Region, T3.Libelle AS ville, 'gn' + CAST(YEAR(T1.DateCourse) AS varchar(4)) + '_' + CAST(CAST(T1.NumTicket AS bigint) AS varchar(30))
+ '_RTC' + CAST(T1.NumCourse AS varchar(6)) AS idGain, dbo.retourneDate(T1.DateCourse) AS DateCourse, T1.NumCourse, T1.idZoneTicket, T1.idControleur,
T1.NumTable, T1.NumTicket, 'RTC' + CAST(T1.NumCourse AS varchar(6)) AS idSerie, T1.TypeJeux, T1.CG, T1.CPA, T1.CPB, T1.CPC, T1.SG, T1.SP, T1.TOd, T1.TD,
T1.TT, T1.ST, T1.Q4O, T1.Q4D, T1.Q4B, T1.Q5O, T1.Q5D, T1.Q5S1, T1.Q5S2, T1.Q5S3, T1.J2sur4, T1.S2sur4, T1.M4, T1.M5, T1.M6, T1.M7, T1.Le6, T1.Remboursement,
T1.Rembourse, T1.TotalGain, T1.DateEnreg, T1.HeureEnreg, T1.idZoneEnreg, T1.TotalPaye, T1.Espece, T1.Cheque, T1.DatePaiement, T1.HeurePaiement,
T1.idZonePaiement, T1.ModePaiement, T1.VilleReverse, T1.Valider, T1.Erreur, T1.idCaissier, T2.idUtilisateur, T1.idVendeur, T2.Flag, T2.Trace, T1.NomParieur,
T1.PrenParieur, T1.PieceId, T1.NumId, T1.DateDelvr, T1.PaysOrigine, T1.NumCheque, T1.SauvNumTicket, T1.des6, T1.bns6, T1.winning_id, T4.Region AS region_paie,
T4.Libelle AS ville_paie, T4.idRegion AS idRegion_paie, T3.idRegion AS idRegion_ticket
FROM dbCommon.dbo.tbGainPaye AS T1 LEFT OUTER JOIN
dbCommon.dbo.tbGain AS T2 ON 'gn' + CAST(YEAR(T1.DateCourse) AS varchar(4)) + '_' + CAST(CAST(T1.NumTicket AS bigint) AS varchar(30))
+ '_RTC' + CAST(T1.NumCourse AS varchar(6)) = 'gn' + CAST(YEAR(T2.DateCourse) AS varchar(4)) + '_' + CAST(CAST(T2.NumTicket AS bigint) AS varchar(30))
+ '_RTC' + CAST(T2.NumCourse AS varchar(6)) INNER JOIN
dbo.VueZone AS T3 ON RTRIM(LTRIM(T2.idZoneTicket)) = T3.idZone LEFT OUTER JOIN |
Partager