how to update last id (last record ) in Sql Server

Question

Hi Programmers Please Help Me how to update last record in table with id by create stored procedures like fields below : StartMileage EndMileage TotalMileage FuelLitres with last insert recod with ID

Nitin Sontakke · Answer

You can: declare @max_id [integer]; select @max_id = max([Id]) from table1 update table1 set column1 = @value1 where Id = @max_id However, are you 100% sure that this is a fool-proof logic. I don't think so, anyway! You are making some assumptions and I don't think these will be true always.

Nilesh Shah · Answer

You can create an auto identity field, its value will be automatically taken care of by SQL Server. While inserting the table values from SP, you can just leave this field, not pass its value at all.

Nitin Sontakke · Answer

Okay. All I am trying to say is updating last record is not a good business logic. Your logic should be more concrete than that. May be a date in a where clause. All I can do is hope that you get my point.

Abdalla Elawad · Answer

Realy this is a part of table also consist from ServiceDate , RotationDate every 30 days the team should be change

Nitin Sontakke · Answer

Even then should there not be a date in it? How do you know to which date that transaction belongs?

Abdalla Elawad · Answer

Good Morning Iam sorry , smae transaction does not insert daily but in fact Monthly .

Nitin Sontakke · Answer

What is the purpose of this table? You say that "every day insert same transaction". If this is the case where is the Date column? Should it not be there?

Abdalla Elawad · Answer

hello dear Please see to attach table , every day insert same transaction its different in lastID only when we need to update the last recored search by TeamNo,City,BankName and update based on last id

Nitin Sontakke · Answer

Just put whatever is given by me in a stored procedure. I hope you already have stored procedures and know how to create new. If not, please do let us know. Just for record: Your logic may look perfect to you, but it is not. Or I don't understand the business logic behind it.

Abdalla Elawad · Answer

Hi Nitin Sontakke I want to Create Stored Procedures for update according to the latest ID entered in the table.

ali tuncer · Answer

SELECT MAX(Id) AS LastID FROM TABLENAME will return last id