It's telling you that the statement

SELECT DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date)

is returning multiple values. Make sure that that this statement is only returning one value for each record in bin_final.


>Dear Sir,
>
>I have these codes
>
>

>  SELECT id,Date,sno,bin,batch,DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date) AS alias
>   FROM bin1_final
>

>
>the above codes work fine, no issue.
>
>Now I want to update column with above codes like this
>
>

> update bin1_final set gap_int=(
>     SELECT DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date) as ddif
>   FROM bin1_final)
>

>
>But it says:
>
>Msg 512, Level 16, State 1, Line 1
>Subquery returned more than 1 value. This is not permitted when the subquery follows ............ or' when the subquery is used as an expression.
>The statement has been terminated.
>
>Please help