Home Forums SQL Server 2008 T-SQL (SS2K8) i want update the 2nd column based on first column: RE: i want update the 2nd column based on first column:

  • No chance you are using SQL Server 2012? Because this would be easy with the new lag/lead functions.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP