blogs.conchango.com

Hi, following on from my previous two posts about Analytic Functions, and specifically about the lack of a T-SQL equivalent to the LAG and LEAD functions I demonstrated, there is a SQL Server feedback vote currently active which you can participate in if you are interested in seeing these functions incorporated into a future update. The vote can ...

For any number of reasons which I won’t go into, you may have a need, or desire, to return a value in a query from one row next to a value from another. A typical example might be in a daily sales database, where I want to see yesterday’s total sales against today’s total sales. It is straight forward enough to write the query to ...