ALTER PROCEDURE GetRateByDate
@Date DateTime
as
declare @Rate numeric(10,1)
set @Rate = nullselect @Rate = MileageRate from MileageInfo where @Date between EffectiveDate and ExpirationDate print @Rate
@Date DateTime
as
declare @Rate numeric(10,1)
set @Rate = nullselect @Rate = MileageRate from MileageInfo where @Date between EffectiveDate and ExpirationDate print @Rate
@Date DateTime
as
declare @Rate numeric(10,1) -----##
set @Rate = nullselect @Rate = MileageRate from MileageInfo where @Date between EffectiveDate and ExpirationDate print @Rate
@Date DateTime
as
declare @Rate numeric(10,1)
set @Rate = nullselect @Rate = MileageRate from MileageInfo where @Date between EffectiveDate and ExpirationDate print @Rate