SQL Server Performance

How to switch to new ID (considering duplicates)

Discussion in 'ALL SQL SERVER QUESTIONS' started by DannyArtavia, Apr 4, 2013.

Thread Status:
Not open for further replies.
  1. DannyArtavia New Member

    Hello!!!

    I need a database from an Insurance company, but they don't want to give it becuase it has a column with the ID number of each patient and their medical history.

    They will give it to me only if I can find a 'script' that allows them to switch that ID number, but I need to 'remember' each ID across all the dase...

    For example,

    If I have (in a column) the ID 12345 and you 54321, y must generate a new number for each one. It can be 1 for me and 2 for you; but each time it reads 12345 it has to change to 1 exclusively.
    In conlution, it has to identify each person with a new ID number.

    Thanks !!![IMG]
  2. FrankKalis Moderator

Thread Status:
Not open for further replies.

Share This Page