Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    11

    Unanswered: comparing two string columns and show difference

    Hello,

    I am having this problem. I have a table to log any changes to the configuration of a program. If something changes, it gets recorded in this table.

    So, I have two columns: BeforeChange, AfterChange. It looks like this:

    BeforeChange AfterChange
    -----------------------------------------------------------------------------
    Amount = 30.00, Quantity = 3 Amount=30.00, Quantity=2

    When I query those changes, I want to show only the changed values.
    So, it will show only:

    ChangeMade
    ----------------
    Quantity = 2


    Can anyone help me on this?

    Thanks in advance.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What about to normalize your table - problem will be resolved by itself.

  3. #3
    Join Date
    Sep 2002
    Posts
    11
    Originally posted by snail
    What about to normalize your table - problem will be resolved by itself.

    The problem is that, this table is filled by a program that I have no access to. (Honestly, I don't really know about the program at all)

    I can only query the modificationlog table, and I have to make a report of any changes made with stored procedure.

    If you can enlighten me a bit more, I would really appreciate it. I'm new to this MS SQL)

    Thank you...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •