Post reply

Select specified records from a full outer join given from and end dates

  • May 29, 2012 at 7:12 am

    #269634

    Hi,

    I have two tables A and B which are joined by the EmployeeBadgeID. I have to capture all the records that have changed in both the tables for a specifed from and to date. If the EndDate is not null in both the tables indicate that a record changed. How do I select only the records which have changed in both the tables for the specified from and to dates from the full outer joined table?

  • May 29, 2012 at 7:18 am

    #1494152

    KS-321165 (5/29/2012)

    Hi,

    I have two tables A and B which are joined by the EmployeeBadgeID. I have to capture all the records that have changed in both the tables for a specifed from and to date. If the EndDate is not null in both the tables indicate that a record changed. How do I select only the records which have changed in both the tables for the specified from and to dates from the full outer joined table?

    In short: http://www.sqlservercentral.com/articles/Best+Practices/61537/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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