how can i update my table with the elapasedsecond as a new coloumn

[nirmalthiruvathilil]

i have generated the difference between two rows of my data using this code.....
now i have the ElapsedSecond as one new row how can i save it into my table??


SELECT *,
DATEDIFF(second, A.End_Time,
(SELECT MIN(Start_Time)
FROM Callbycall as B
WHERE A.Agent = B.Agent
AND A.Start_Time < B.End_Time)) as ElapsedSecond
FROM Callbycall as A

[nbiswas]

Try something like

insert into tablename
select * from tablename

syntax

e.g.

insert into Callbycall
 
SELECT *,
DATEDIFF(second, A.End_Time,
(SELECT MIN(Start_Time)
FROM Callbycall as B
WHERE A.Agent = B.Agent
AND A.Start_Time < B.End_Time)) as ElapsedSecond
FROM Callbycall as A

Hope this helps

[nirmalthiruvathilil]

will this code help me to update the table which i am having..
this is insert i would like to hava a update statement which would help me to insert the values.

[nbiswas]

The general syntax for this case is

UPDATE <destinationtablename>
SET <destinationtablename.columnname> = <sourcetablename.columnname>
FROM < sourcetablename >
    INNER JOIN < destinationtablename >
    ON (<destinationtablename.columnname> = <sourcetablename.columnname>);

Coming to your program, try this(you may need to modify a bit as I don't have the exact schema)

UPDATE DESTINATION_TABLE
SET DESTINATION_TABLE.ElapsedSecond= S.ElapsedSecond
FROM 
(SELECT *,
DATEDIFF(second, A.End_Time,
(SELECT MIN(Start_Time)
FROM Callbycall as B
WHERE A.Agent = B.Agent
AND A.Start_Time < B.End_Time)) as ElapsedSecond
FROM Callbycall as A) S
 
INNER JOIN DESTINATION_TABLE D
ON D.JOIN_FIELD_NAME = S.JOIN_FIELD_NAME

I have given a similar response to you question here how to insert the value of a function in the coloum

Hope this helps