Sir, I am using SQL SERVER 2008.

Suppose I have following data

CREATE CURSOR junk(date t,nSeconds n(4))
INSERT INTO junk values({^2019-02-08 01:25:28 AM},	0)
INSERT INTO junk values({^2019-02-08 01:25:29 AM},	0)
INSERT INTO junk values({^2019-02-08 01:25:55 AM},	0)
INSERT INTO junk values({^2019-02-09 02:28:29 AM},	0)
INSERT INTO junk values({^2019-02-09 02:50:18 AM},	0)
INSERT INTO junk values({^2019-02-09 08:59:17 PM},	0)
INSERT INTO junk values({^2019-02-09 10:25:39 PM},	0)
INSERT INTO junk values({^2019-02-12 03:05:19 AM},	0)

I want to fill nSeconds column like this
For second record

AA={^2019-02-08 01:25:29 AM}-{^2019-02-08 01:25:28 AM}   && 1 Second

Second() difference with Previous record.

I need result shown in attached file

I want to update JUNK table in sqlserver.

Thanks in advance