Monthly Archives: Νοέμβριος 2015

Yesterday I had discussed two analytical functions FIRST_VALUE and LAST_VALUE. After reading the blog post I received very interesting question. «Don’t you think there is bug in your first example where FIRST_VALUE is remain same but the LAST_VALUE is changing every line. I think the LAST_VALUE should be the highest value in the windows or…

Πηγή: SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Journey to SQL Authority with Pinal Dave

Πηγή: Lead And Lag Functions In SQL Server

This article outlines methods to calculate previous month, quarter, or previous period from a current period column in a date dimension or other table.

Πηγή: Calculate previous month, quarter without using string gymnastics – Daniel Bowlin’s SQL Server BI Blog

http://www.c-sharpcorner.com/UploadFile/746cd9/generate-sql-scripts-of-the-table-with-records-and-restore-i/