Home Forums SQL Server 2017 SQL Server 2017 - Development SQL Server Over Partition RE: SQL Server Over Partition
dangelo211
SSC Enthusiast
Points: 160
More actions
January 2, 2018 at 8:59 am
#1974086
remove duplicate consecutive rows using the key PI, m and TT.
Create transactions when PI, M, TT changes based on the order of date. When TT changes a new transaction needs to be created.