1 2 3 4 5 6 7 8 9 10 11 12 13
|
declare @nb_mt varchar(10)
declare @reket_nb varchar(500)
declare @reket_mt varchar(500)
declare @JourMin varchar(10)
set @nb_mt='Montant'
set @JourMin = '01-01-08'
set @reket_nb = 'select mois,nbrecharge,MontantTotalRecharge,ValeurFaciale,Jour from dbo.table where Jour>=@JourMIn '
set @reket_mt = 'select mois,nbrecharge as MontantTotalRecharge,MontantTotalRecharge as nbrecharge,ValeurFaciale,Jour from dbo.table where Jour>=@JourMIn'
if @nb_mt='Montant'
exec(@reket_mt)
else
exec(@reket_nb) |
Partager