Home Forums SQL Server 2014 Development - SQL Server 2014 Can i put a select in an ISNULL Statement? RE: Can i put a select in an ISNULL Statement?

  • March 8, 2018 at 12:27 pm

    #1982546

    jeffshelix - Thursday, March 8, 2018 11:48 AM

    crude example,
    the REAL price might not be in DBO.RealPrice,but it will be in DBO.OLDPRICE.

    Can i do something like this:

    Select
    yada A,
    yada B,
    ,ISNULL(RealPrice, Select OLDPRIOE from DBO.OLDPRICE...)

    trying to save some time

    Yes, but why would you want to?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/