1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| declare @Montant as float
declare @Libelle as varchar(20)
declare @Libelle2 as varchar(20)
set @Montant = '3538.36'
set @Libelle = 'VIR'
select @libelle2 = +'%' +@libelle +'%';
select
t1.[Cust_ Ledger Entry No_] as sequence,
T3.[Document No_],
case
when (T3.[N° Affaire]) = '' then T3.[No Affaire]
end as Affaire,
convert(char(10),T1.[Posting Date],103) as Date,
t1.[Initial Entry Global Dim_ 1] as Agence,
t1.[Customer No_] as Num_Client,
t2.[Name] as Noms_Client,
cast(t1.Amount as decimal(18,2)) as Montant_TTC
from dbo.[societe$Detailed Cust_ Ledg_ Entry] t1
inner join dbo.[societe$Customer] t2
on t2.No_ = t1.[Customer No_]
inner join dbo.[societe$Cust_ Ledger Entry] T3
on T3.[Entry No_] = t1.[Cust_ Ledger Entry No_]
where t1.Amount like @Montant
and t2.[Name] like @Libelle2
order by T1.[Posting Date] desc |
Partager