Probleme avec Like et une variable
Bonjour,
J'ai cette requete qui ne trouve aucun resultat, alors que je sais qu'elle existe la reponse car si je l'essaye sans variable je trouve mes ecritures , et si je remplace les valeurs par des variables , la requete ne retourne rien. Pouvez vous me dire ou je me suis trompé 8O:
Code:
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 |
MERCI