Hey,
here is the table & it contains timestamp at the end. check the output
create table customer (CustomerName char(22), ContactName char(22), Address char(22), City char(22)
, PostalCode char(22), Country char(22),time DATETIME DEFAULT GETDATE())
INSERT INTO customer (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
INSERT INTO customer (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal1', 'Tom B. Erichsen1', 'Skagen 211', 'Stavanger1', '4001', 'Norway1');
INSERT INTO customer (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal2', 'Tom B. Erichsen2', 'Skagen 212', 'Stavanger2', '4002', 'Norway2');
INSERT INTO customer (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal2', 'Tom B. Erichsen2', 'Skagen 212', 'Stavanger2', '4002', 'Norway2');
for row 2nd row , it should take previous timestamp +1 second
for 3rd row, it should take next timestamp -1 second and it should keep happen when more records added
![User's image](https://learn-attachment.microsoft.com/api/attachments/e34e4df0-0efa-4a9a-8c55-aae7db9698c2?platform=QnA)
desired:
![User's image](https://learn-attachment.microsoft.com/api/attachments/69579ef0-ed03-4d75-a00d-0b2e535d8508?platform=QnA)