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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

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

787 reads

Blogs

Only a little break for me. I’m actually heading to Las Vegas today for ...

I have a presentation on finding balance in your career that got quite a...

But as I've matured over the years, I came to realize that I needed...

Comments posted to this topic are about the item The day-to-day pressures of a...

Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...

Comments posted to this topic are about the item Identities and Sequences III

When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?