welcome[bot]
commented
3 years ago Thank you for creating the issue! One of our team members will get back to you shortly with additional information. If this is a product issue, please close this and contact the particular product's support instead (see https://support.microsoft.com/allproducts for the list of support websites).
rootsmusic
On the LAG (Transact-SQL) page https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15 The last example appears to have a typo. The result Year and Quarter appear as Year Quarter 2001 3 2001 4 2001 1 2002 2 2002 3 2002 4 Based on the query for the example the year in bold “2001” should be “2002”