This is my query.

Here , I have calculated InTime and OutTime .

Query:

=====

Select

(CASE(Cur.Status) WHEN 'OUT' THEN

(CASE(Prv.Status) WHEN 'IN' THEN

RIGHT(('0'+Convert(varchar,(sum(DateDiff(mi,Prv.Time,Cur.Time)/60)))),2)+':'

+RIGHT(('0'+Convert(varchar,(sum(DateDiff(mi,Prv.Time,Cur.Time)%60)))),2)

ELSE '' END)

ELSE '' END) AS InTime,

(CASE(Cur.Status) WHEN 'IN' THEN

(CASE(Prv.Status) WHEN 'OUT' THEN

RIGHT(('0'+Convert(varchar,(sum(DateDiff(mi,Prv.Time,Cur.Time)/60)))),2)+':'

+RIGHT(('0'+Convert(varchar,(sum(DateDiff(mi,Prv.Time,Cur.Time)%60)))),2)

ELSE...

This is my query.

Here , I have calculated InTime and OutTime .

Query:

=====

Select

(CASE(Cur.Status) WHEN 'OUT' THEN ...

during insertion of test1 table, automatically insert the values into test_audit table using trigger.

Thanks