lokesh.sehgal | SQLServerCentral

lokesh.sehgal

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

RE: Trying To filter Data using LAG() and LEAD() functions

ChrisM@Work - Wednesday, August 30, 2017 3:12 AM
lokesh.sehgal - Wednesday, August 30, 2017 2:50 AM

August 30, 2017 at 3:59 am

#1957398
RE: Trying To filter Data using LAG() and LEAD() functions

twin.devil - Wednesday, August 30, 2017 3:38 AM
lokesh.sehgal - Wednesday, August 30, 2017 2:50 AM

August 30, 2017 at 3:57 am

#1957397
RE: Trying To filter Data using LAG() and LEAD() functions

lokesh.sehgal - Wednesday, August 30, 2017 1:45 AM
twin.devil - Wednesday, August 30, 2017 1:31 AM

August 30, 2017 at 2:50 am

#1957380
RE: Trying To filter Data using LAG() and LEAD() functions

GilaMonster - Wednesday, August 30, 2017 2:14 AM
Formatted to be readable. The test1 CTE is used, I do recommend more meaningful names...

August 30, 2017 at 2:48 am

#1957378
RE: Trying To filter Data using LAG() and LEAD() functions

twin.devil - Wednesday, August 30, 2017 1:31 AM
1st of all, please share the DDL along with some sample data. secondly, your upload...

August 30, 2017 at 1:45 am

#1957363

Viewing 5 posts - 1 through 5 (of 5 total)