SELECT vm.RegistrationNo, OilChangeOdometer, OilChangeDate, ServicingOdometer, ServicingChangeDate, TyreChangeOdometer, TyreChangeDate, driverid, drivername, licenseexpiry, contact, vh.Insurancestartdate, vh.insuranceexpirydate, vh.insurancecompany FROM VehicleMaintance AS vm FULL OUTER JOIN vehicle_master AS vh ON vm.RegistrationNo = vh.RegistrationNo WHERE vm.RegistrationNo = @vehId AND ((OilChangeDate BETWEEN @strFromDt AND @strToDt) OR (ServicingChangeDate BETWEEN @strFromDt AND @strToDt) OR (TyreChangeDate BETWEEN @strFromDt AND @strToDt));
SELECT CAST(GETDATE() AS DATE)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)