SQL code for using preceding values

Question

Question by msridha2 · Oct 02, 2020 at 12:41 AM · sql code

Hi I need the value in 'Needed' column, logic is provided below

capture.png (43.1 KiB)

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-11-02T01:47:36Z

Answer by Jeff Moden · Nov 02, 2020 at 01:47 AM

Lookup up the LAG function (teaching someone how to fish) if you're using at least SQL Server 2012. Actually, here's the link ...

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.