LEAD Function in 2008

LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (10)

You rated this post out of 5. Change rating

2016-06-28 (first published: 2016-05-18)

782 reads

Blogs

There are some fundamental boxes that your reporting system must tick. ✅ The figures...

When it comes to managing complex database environments, having the right monitoring solution is...

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

Comments posted to this topic are about the item Create an HTML Report on...

Comments posted to this topic are about the item The Last Good DBCC Run

Hi everyone I have a SP that finds the average based on 3 tables. ...

I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?