Post reply

Scrambling data which has no constraints

  • December 10, 2011 at 11:55 am

    #261376

    Hi,

    I would like to scramble two tables( Table A and Table B) for ID columns, which doesn't have any constraints. After scrambling I would like to see the similar scrambled data on both tables. Is there any script we can do that so we can have same data on columns after scrambling. I tried using abs function and joins but it didn't worked out. Please assist me. Thank you

  • December 11, 2011 at 4:42 am

    #1419786

    Please help us to help you.

    What we expect from you is: tables DDLs, sample data & your expected output.

    If you provide it, many guys here would be able to help you.

  • December 11, 2011 at 8:31 am

    #1419808

    haivenki3 (12/10/2011)

    Hi,

    I would like to scramble two tables( Table A and Table B) for ID columns, which doesn't have any constraints. After scrambling I would like to see the similar scrambled data on both tables. Is there any script we can do that so we can have same data on columns after scrambling. I tried using abs function and joins but it didn't worked out. Please assist me. Thank you

    The answer is "Absolutely" but, as Dev suggested, we don't have enough information about your particular requirements to actually help. Please see the first link in my signature line below for how to best help us help you. Thanks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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