Need help with a view to show difference in week numbers between sequential records 1

[dinzana]

i need to find out the difference between sequential week numbers and store the value on the current weeks row. How can i do this is a view. I have
id, shipped and week number columns as shown here, I need to get the 'desired value' column to use as a denominator. Any ideas? Great thanks in advance.

 

[GHolden]

Hi, if you're using SQL Server 2012 or newer check out Lead and Lag

Explained here:

https://blog.sqlauthority.com/2011/...ytic-functions-introduced-in-sql-server-2012/

Regards

There are two ways to write error-free programs; only the third one works.

 

[dinzana]

Perfect! Thanks so much!!