my select query :-
SELECT s1.Car_id ',
s1.Job_Card ',
s1.Value_Oil ',
s1.Change_date ',
s1.Current_Dist ',
s1.Prev_Dist ,
Drivers.Driver_Name '',
Oil_Type.Oil_Type as ',
s1.QTY ',
s1.Filter ',
s1.Notes '
FROM Change_Oil s1
inner join (select Car_id, MAX(Change_date) as 'Max date '
from Change_Oil
group by Car_id ) s2
on s1.Car_id = s2.Car_id
and s1.Change_date = s2.[Max date]
INNER JOIN dbo.Oil_Type
ON s1.Oil_id = dbo.Oil_Type.Oil_id
INNER JOIN dbo.Drivers
ON s1.Driver_ID = dbo.Drivers.Driver_ID
where s1.Car_id = s2.Car_id
this is my update Query :-
create proc UPDATE_CHANGE_OIL
@car_id int,
@job_card varchar(8),
@value_oil numeric(18, 2),
@change_date date,
@current_dist numeric(18, 2),
@prev_dist numeric(18, 2),
@drive_id int,
@oil_id int,
@qty numeric(18, 2),
@filter bit,
@notes text
as
update Change_Oil
set Car_id = @car_id,
Job_Card = @job_card,
Value_Oil = @job_card,
Change_date = @change_date,
Current_Dist = @current_dist,
Prev_Dist = @current_dist,
Oil_id = @oil_id,
QTY = @qty,
Filter = @filter,
Notes = @notes
where Car_id = @car_id
when i update the row Determined in data grid view please i want where my mistake in Update Query