Post reply

Replace column data with column data of another table

  • April 20, 2013 at 7:56 am

    #1608477

    one way to consider

    SELECT

    A.Empid,

    ISNULL(B.WeekoffChangeDate, A.WeekoffDate) AS ActualWeekOffDate

    FROM Table_A AS A

    LEFT OUTER JOIN Table_B AS B ON A.WeekoffDate = B.WeekoffDate

    AND A.Empid = B.Empid

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • April 25, 2013 at 3:17 am

    #1609829

    Thank you very much.. it worked out for me

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply