Home Forums SQL Server 2008 T-SQL (SS2K8) compare two columns RE: compare two columns

  • December 5, 2016 at 3:56 am

    #1915949

    peter478 (12/5/2016)

    Thank you , btw. sometimes has column2 value = NULL and result is also NULL. I this case I want to put date from column1.

    CASE

    WHEN column1 >= ISNULL(column2,Column1)

    THEN column1

    ELSE column2 END AS Result

    This will handle that situation.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537