Home Forums SQL Server 2008 T-SQL (SS2K8) SQL query eliminating rows problem RE: SQL query eliminating rows problem

  • September 22, 2012 at 10:11 pm

    #1541135

    CELKO (9/22/2012)

    LAG(screwup_flg) OVER (PARTITION BY claim_nbr ORDER BY claim_seq)

    LAG is a good alternative solution for SQL Server 2012 (though not necessarily better performing).

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi